Hello and I hope you can help,

I am just upgrading from CMS Version 9.0.6.1 to 9.1.2.1 and ran the installer.. Here's the error message at database set up stage..

On /install.php?
While executing query "ALTER TABLE cms_users CHANGE user_regdate user_regdate INT NOT NULL DEFAULT '0'"

the following error occured: Incorrect integer value: '' for column 'user_regdate' at row 1

In: C:\Inetpub\Www_root\includes\classes\installer.php on line: 111

Any help would be greatly appeciated..pls help

Many thanks in advance

MySQL 4.0.25 ?

Hello and thanks,

I must apologise as my server specs were out of date as I am in the process of migrating to a new server so took the opportunity to ugrade evertything.

I found the solution, connected to something complety else but seemed to fix that issue.

It is MySql 5.0 that does it. If you have MySql with Stric mode you get this error.

In My.ini find the line that has :
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"

and change it to:
# Set the SQL mode to strict
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"

Anyway, that done I now recieve this error at the bottom of the page...

INSERT INTO cms_bbsmilies VALUES (DEFAULT, ':D', 'icon_biggrin.gif', 'Very Happy')
Column count doesn't match value count at row 1

Please contact the CPG-Nuke Dev Team about the error
You cannot continue with the installationThe database has been properly updated, have fun with your incredible Dragonfly!
Remove install.php and the install directory right now!

any ideas..

My Spec:

MySQL 5
PHP 5.2.3
IIS 6

Changing MySQL mode is not the fix, but just a workaround.

The upgrade is trying to insert an empty registration date for some of your users. I would love to investigate why it is doing it since few users had the same problem. At this point I'm not sure if the empty registration date was there already by a previuos bug or the installer is failing to convert the registration date (could be UNIX_TIMESTAMP issue).

I'll be glad if you could go trough your users registration dates to check if there is any empty or strange value. If you don't see anything wrong try to post here at least one one the registration date that populate your users table.

The second error it was not suppose to happen ... I'll look into it.

At this point I'll suggest you to wait a bit longer before upgrading.

ok and thanks nano, been putting off the upgrade for ages!!

Many thanks for your help and look forward to any further releases that will solve this issue.

will look into the dates now and post any unusual results if I find any.

The bbsmilies error was a bug for new installs only or if the bbsmilies table was empty. However I've fix it in the current release (zip and 7z only) under the same name 9.1.2.1.

Tomorrow I'll update tarball archives and release a bug fixed version.

[edit]"The bbsmilies error was a bug for new installs only or if the bbsmilies table was empty" IF MySQL was running with STRICT_TRANS_TABLE[/edit]

Thanks, and sorry for mis-understanding..does this mean the latest cms download here will correct this error on my installation?

I have also realised that checking through those user reg dates is not easy!! over 39000 of them...is there a simple way?

Thanks so much for your help

try
dragonflycms.org/Forum...tml#130381

Yes the current 9.1.2.1 download will fix your bbsmilies issue ONLY.
IF we are able to fix the registration date then tomorrow I'll be able to definitively release a new bug fixed version + tarball archives.

[edit]removed queries in favor of a script[/edit]

thanks, and sorry my noobie'ness....

I've had quite a look and that field is populated with - "0"

Is there a string to pull out from my cms_users table that doesn't have this value, I am not sure what should be in there :-/

Sorry and thanks, and that sounds just excellent - great support

sorry, downloading the csv users table now....

ok, all fields are populated with the value 0

Are both query returning "0".

Also what you mean with "downloading the csv users table now." ?

I'm not saying to download any "cvs" here but to re-download 9.1.2.1 package.

However until, as I stated before, until we are not sure about the regdate I'll suggest you to wait before upgrading.

If you want to upgrade you are free to but keep the old backup.

apologies for the confusion.

I meant I extracted my cms_user table to a .csv file to check all the entries and they all contained the value of 0.

As I am half way through the install, I will wait until the fix, many thanks again.

Having exact the same with :

Dragonfly9.1.2.1.7z

downloaded minutes ago.

Apache version 1.3.37 (Unix)
PHP version 5.2.1
MySQL version 5.0.27-standard-log
MySQL client version: 4.1.10

SQL_Mode field is blank.

Read the topic.

NanoCaiordo wrote:

http://dragonflycms.org/Forums/viewtopic/p=130330.html#130330