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

[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.