News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

coverting from Yabbse 1.5.1... Unknown column 'lastUpdated' in 'field list'

Started by evildrome, April 28, 2007, 03:08:10 PM

Previous topic - Next topic

evildrome

Hi All,

I got this when converting from Yabbse 1.5.1 to SMF 1.1

Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
UPDATE `pgoff_smf1`.smf_boards
SET memberGroups = '-1,0,2', lastUpdated = 1177787359
WHERE ID_CAT = 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'


Seems unlikely. Is my database corrupt? I am installing SMF because my code base is definitely corrupt. This happened after my ISP had a problem and reloaded the site from a backup.

http://www.pgoffline.com/yabbse/ [nofollow]


Cheers,

Wilson.


evildrome

OK, I checked table 'smf_boards' and, right enough, there is no field 'lastUpdated', which makes me wonder if the install of SMF I did, failed in some way.

Can anyone confirm that 'lastUpdated' is a field in  table 'smf_boards' ?

Thanks,

Wilson.

-christian

This es exactly the error that I got over here as well. I can confirm this. Is there any workaroud for this? Any help appreciated.

Ingo Monk

I got the same error:
----------
Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:

    UPDATE `bullhodr_ingo`.smf_boards
    SET memberGroups = '-1,0,2', lastUpdated = 1185514137
    WHERE ID_CAT = 2;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'
----------

Can anyone tell me what's causing the issue?  Thanks in advance! :)

UPDATE
Err forgot the relevant info:
YaBBSE 1.5.1 installed, trying to convert to SMF 1.1.3
Using YaBBSE 1.5.x to SMF converter
Followed the instructions explicitly.

UPDATE 2
Fixed the error.  Need to overwrite the yabbse_to_smf.sql file in the SMF install.  File is provided by Jay Bachatero in the [SMF Converter] YaBB SE 1.5.4 sticky in this subforum.

Thanks Jay!!!

redone

Thanks for posting you that you found the solution. I am in the process of getting the downloads updated.

;)

Advertisement: