Import fails with 1364: Field 'ghobs_commenterId' doesn't have a default value.

riiser

Joined: 2002-08-16
Posts: 8
Posted: Fri, 2007-02-09 13:07


G2 version: Gallery version = 2.1.2 core 1.1.0.2
G1 version: Gallery v1.5.5-pl1
G1 character set: Eh. Not sure what this means. G1 is in ENGLISH mode ? eh ? (Sorry)
PHP memory limit: memory_limit = 54M ; Maximum amount of memory a script may consume (16MB)
--
PHP version (e.g. 4.3.11): PHP version = 5.2.0 cgi-fcgi
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33): Webserver = Microsoft-IIS/6.0
Database (e.g. MySql 4.0.11): Database = mysql 5.0.27-community-nt-log, lock.system=database
Activated toolkits (e.g. NetPbm, GD): Toolkits = Thumbnail, ImageMagick
Operating system (e.g. Linux): Operating system = Windows NT 5.2 build 3790
Browser (e.g. Firefox 1.0): Browser = Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1

Doing import from Gallery-1 v1.5.5-pl1 to Gallery-2.1.2

Gallery v1 integrity checked out ok by using the "validate albums" from Admin Options.

Gallery 1 has been an part of php-nuke, phpbb, embedded thing. SO the G1 has no users whatsoever. Although the G1 has allot of funny user comments that really wants to be saved.

Got the Gallery2 Up and running fine. Made test album and got an picture in it.

Not using any EXIF and GD tools. ImageMagick is the one at the moment.

Fire up the import gallery1 script. Import users shows only admin. Thats expected. Targets one of the g1 albums. And start the import.

Fails at once. Memory usage 0, shows the pic.jpg and No continue what-so-ever.

So now I Enabled debugging. After some lurking, i read at the end of the output: "1364: Field 'ghobs_commenterId' doesn't have a default value"

Guess what, I figured that has to do with the comments of pictures. Sure enough. If I strip the picture of its comments. It imports fine.

SO my question is:

"How do I set the comenterId to an default value" ?

Yours,
Christian

[spelling edit. Duh me :-) ]
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2007-02-09 13:18

this is probably related to your g1 being integrated into phpnuke.
i'll ask another dev who migrated a g1 that was integrated with phpbb to g2. it's a little more complicated than migrating a normal g1.

--------------
Enter the Gallery 2 Theme Contest today!
 
riiser

Joined: 2002-08-16
Posts: 8
Posted: Fri, 2007-02-09 13:34

Great news... Eh well sorta :) I guess what really is needed is someway of assigning the commentID to anonymous and/or admin too. as the owner is :-)
 
joe7rocks
joe7rocks's picture

Joined: 2004-10-07
Posts: 560
Posted: Fri, 2007-02-09 14:05

Hi,
I'm this 'another dev'.

First of all, I'm sorry, but I've done this migration almost 2 years ago, so I don't really remember :(

I'm thinking about it, but I don't recall what have I done to the 'no user' stuff. I might just added users manually 1by1 then associated each of them with their albums. (I could have no more than a few dozens embedded users that time)
I'll do a search in my backups and get back to you if I find any script which could handle this though.

CommenterIds: I did not have this error, but the migrations script -especially the part related to importing of comments- has changed since then.

linkfelhő | Dog gallery
 
riiser

Joined: 2002-08-16
Posts: 8
Posted: Fri, 2007-02-09 14:11

Hi and thank you for responding so fast !

This is sad news. I have more than 400 users. Only a few of them where allowed to make albums and that is not the concern to get the right owner of the albums. The thing is to preserve the comments :-)

The error only shows up when you enable debug. Otherwise it just seems hung.. :(

Can I assist in anyway to resolve this ??

Regards.