Author Topic: [3.4.0.7] Installer can't import sql data  (Read 16418 times)

Lupu

  • Newbie
  • *
  • Posts: 6
    • View Profile
[3.4.0.7] Installer can't import sql data
« on: January 06, 2016, 01:39:41 pm »
I had to alter the sql schema in order to complete the install process (workspace and core plugin failed to import data)

Code: [Select]
- table: members
`description` TEXT,      ( -> removed NOT NULL )

- table: widgets
`path` varchar(512),     ( -> removed NOT NULL )
`default_options` text,  ( -> removed NOT NULL )


Later Edit:

Steps to reproduce:
Code: [Select]
# Ubuntu 14.04
apt update
apt upgrade
reboot
apt install apache2 php5 php5-gd php5-mysql php5-curl php5-xmlrpc
wget "http://downloads.sourceforge.net/project/opengoo/fengoffice/fengoffice_3.4.0.7/fengoffice_3.4.0.7.zip?r=&ts=1452165748&use_mirror=vorboss" -O fengoffice_3.4.0.7.zip
unzip fengoffice_3.4.0.7.zip -d /var/www/html/
chown www-data:www-data -R /var/www/html/fengoffice

// create mysql database feng collate utf8_general_ci on different server

Step 4 fails with 2 errors:
- Error while loading inital data for plugin 'core_dimensions'.Field 'description' doesn't have a default value
- Error while loading inital data for plugin 'workspaces'.Field 'path' doesn't have a default value
« Last Edit: January 07, 2016, 08:38:22 am by Lupu »

FuturepIlot

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: [3.4.0.7] Installer can't import sql data
« Reply #1 on: February 08, 2016, 01:05:44 am »
I'm running into the same problems you are on Debian. The installer seems very broken. How exactly did you fix it?

natalia.martinez

  • Administrator
  • Freshman
  • *****
  • Posts: 47
    • View Profile
Re: [3.4.0.7] Installer can't import sql data
« Reply #2 on: March 08, 2016, 01:44:24 pm »
Hi FuturepIlot and Lupu,

This is related to the way MySql is configured. Could you check this?
The problem is produced when you insert a log and do not specify a column. If this column does not have a default value defined on the table, it fails.

You can check this so that it only gives you a warning instead of an error in these cases.

Best regards,
Natalia.

FuturepIlot

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: [3.4.0.7] Installer can't import sql data
« Reply #3 on: March 28, 2016, 04:49:44 pm »
Hi FuturepIlot and Lupu,

This is related to the way MySql is configured. Could you check this?
The problem is produced when you insert a log and do not specify a column. If this column does not have a default value defined on the table, it fails.

You can check this so that it only gives you a warning instead of an error in these cases.

Best regards,
Natalia.

What am I checking exactly?

natalia.martinez

  • Administrator
  • Freshman
  • *****
  • Posts: 47
    • View Profile
Re: [3.4.0.7] Installer can't import sql data
« Reply #4 on: April 07, 2016, 12:13:43 pm »
Hi,

To disable the error when inserting a row without specifying all columns you can disable the strict mode in mysql.
To check if strict mode is enabled you can run the following query:
SELECT @@SQL_MODE
Please check if any of these values is present:
TRADITIONAL, STRICT_TRANS_TABLES, STRICT_ALL_TABLES
If any of them is present please try changing the sql mode without including it.

To change this option you can edit the configuration file (my.cnf) and set the variable:
sql-mode=""

Hope this helps!

Best regards,
Natalia



EfrainTox

  • Newbie
  • *
  • Posts: 2
    • ICQ Messenger - 144812185
    • Yahoo Instant Messenger - hydraclubbioknikokex7njhwuahc2l6
    • View Profile
    • hydraclubbioknikokex7njhwuahc2l67lfiz7z36md2jvopda7nchid onion
    • Email
?????? ?? ?????
« Reply #7 on: March 30, 2022, 02:15:13 pm »

MathProrb

  • Newbie
  • *
  • Posts: 3
    • ICQ Messenger - 257671715
    • Yahoo Instant Messenger - Cool math  games online on brows
    • View Profile
    • Cool math  games online on browser!
    • Email
Cool math games online on browser!
« Reply #8 on: April 04, 2022, 08:45:35 am »
Please read on for more information if this sounds like. 7 of the greatest free online cool math games online papa's pizzeria for kids is included in this post.
 
https://play-coolmathgames.com/

CharlesSed

  • Hero Member
  • *****
  • Posts: 682
    • ICQ Messenger - 217766114
    • Yahoo Instant Messenger - After Hours Alcohol Delivery Mis
    • View Profile
    • After Hours Alcohol Delivery Mississauga
    • Email
After Hours Alcohol Delivery Mississauga
« Reply #9 on: April 14, 2022, 12:56:23 am »
<a href="https://alcoholdeliverymississauga.com/">After Hours Alcohol Delivery Mississauga</a>
If you're looking for alcohol delivery in Mississauga, you've come to the right place!
 
We deliver from the beer store and the LCBO with the image of liquor.
 
<a href="https://alcoholdeliverymississauga.com/">Alcohol Delivery Mississauga</a> is the most popular dial-a-bottle service. We supply LCBO and alcohol to consumers all around the city, from Toronto Pearson Airport to Queen Elizabeth Way.
Now is the time to order a bottle! We offer the alcohol and deliver it to your house in 45 minutes or less.
After Hours Alcohol Delivery Mississauga

CharlesSed

  • Hero Member
  • *****
  • Posts: 682
    • ICQ Messenger - 217766114
    • Yahoo Instant Messenger - After Hours Alcohol Delivery Mis
    • View Profile
    • After Hours Alcohol Delivery Mississauga
    • Email
After Hours Alcohol Delivery Mississauga
« Reply #10 on: April 14, 2022, 12:58:23 am »
<a href="https://alcoholdeliverymississauga.com/">After Hours Alcohol Delivery Mississauga</a>
If you're looking for alcohol delivery in Mississauga, you've come to the right place!
 
We deliver from the beer store and the LCBO with the image of liquor.
 
<a href="https://alcoholdeliverymississauga.com/">Alcohol Delivery Mississauga</a> is the most popular dial-a-bottle service. We supply LCBO and alcohol to consumers all around the city, from Toronto Pearson Airport to Queen Elizabeth Way.
Now is the time to order a bottle! We offer the alcohol and deliver it to your house in 45 minutes or less.
After Hours Alcohol Delivery Mississauga

CharlesSed

  • Hero Member
  • *****
  • Posts: 682
    • ICQ Messenger - 217766114
    • Yahoo Instant Messenger - After Hours Alcohol Delivery Mis
    • View Profile
    • After Hours Alcohol Delivery Mississauga
    • Email
After Hours Alcohol Delivery Mississauga
« Reply #11 on: April 14, 2022, 12:59:00 am »
<a href="https://alcoholdeliverymississauga.com/">After Hours Alcohol Delivery Mississauga</a>
If you're looking for alcohol delivery in Mississauga, you've come to the right place!
 
We deliver from the beer store and the LCBO with the image of liquor.
 
<a href="https://alcoholdeliverymississauga.com/">Alcohol Delivery Mississauga</a> is the most popular dial-a-bottle service. We supply LCBO and alcohol to consumers all around the city, from Toronto Pearson Airport to Queen Elizabeth Way.
Now is the time to order a bottle! We offer the alcohol and deliver it to your house in 45 minutes or less.
After Hours Alcohol Delivery Mississauga

CharlesSed

  • Hero Member
  • *****
  • Posts: 682
    • ICQ Messenger - 217766114
    • Yahoo Instant Messenger - After Hours Alcohol Delivery Mis
    • View Profile
    • After Hours Alcohol Delivery Mississauga
    • Email
After Hours Alcohol Delivery Mississauga
« Reply #12 on: April 14, 2022, 01:01:02 am »
<a href="https://alcoholdeliverymississauga.com/">After Hours Alcohol Delivery Mississauga</a>
If you're looking for alcohol delivery in Mississauga, you've come to the right place!
 
We deliver from the beer store and the LCBO with the image of liquor.
 
<a href="https://alcoholdeliverymississauga.com/">Alcohol Delivery Mississauga</a> is the most popular dial-a-bottle service. We supply LCBO and alcohol to consumers all around the city, from Toronto Pearson Airport to Queen Elizabeth Way.
Now is the time to order a bottle! We offer the alcohol and deliver it to your house in 45 minutes or less.
After Hours Alcohol Delivery Mississauga

CharlesSed

  • Hero Member
  • *****
  • Posts: 682
    • ICQ Messenger - 217766114
    • Yahoo Instant Messenger - After Hours Alcohol Delivery Mis
    • View Profile
    • After Hours Alcohol Delivery Mississauga
    • Email
After Hours Alcohol Delivery Mississauga
« Reply #13 on: April 14, 2022, 01:01:39 am »
<a href="https://alcoholdeliverymississauga.com/">After Hours Alcohol Delivery Mississauga</a>
If you're looking for alcohol delivery in Mississauga, you've come to the right place!
 
We deliver from the beer store and the LCBO with the image of liquor.
 
<a href="https://alcoholdeliverymississauga.com/">Alcohol Delivery Mississauga</a> is the most popular dial-a-bottle service. We supply LCBO and alcohol to consumers all around the city, from Toronto Pearson Airport to Queen Elizabeth Way.
Now is the time to order a bottle! We offer the alcohol and deliver it to your house in 45 minutes or less.
After Hours Alcohol Delivery Mississauga

CharlesSed

  • Hero Member
  • *****
  • Posts: 682
    • ICQ Messenger - 217766114
    • Yahoo Instant Messenger - After Hours Alcohol Delivery Mis
    • View Profile
    • After Hours Alcohol Delivery Mississauga
    • Email
After Hours Alcohol Delivery Mississauga
« Reply #14 on: April 14, 2022, 01:03:35 am »
<a href="https://alcoholdeliverymississauga.com/">After Hours Alcohol Delivery Mississauga</a>
If you're looking for alcohol delivery in Mississauga, you've come to the right place!
 
We deliver from the beer store and the LCBO with the image of liquor.
 
<a href="https://alcoholdeliverymississauga.com/">Alcohol Delivery Mississauga</a> is the most popular dial-a-bottle service. We supply LCBO and alcohol to consumers all around the city, from Toronto Pearson Airport to Queen Elizabeth Way.
Now is the time to order a bottle! We offer the alcohol and deliver it to your house in 45 minutes or less.
After Hours Alcohol Delivery Mississauga