Good afternoon...
I was with vbulletin 4.1.0 upgrading from 3.8.5 and i used to have error 1054 each time i tried to move an existing forum or thread.
I read in similar threads that this is caused usually when not all of the upgrade files are installed correctly so i did a new upgrade this time upgrading to 4.1.5 but alas i have the same problem.
The error message is the following...
Before the upgrade i closed my forum and i run the upgrade.php...any help would be appreciated.
I was with vbulletin 4.1.0 upgrading from 3.8.5 and i used to have error 1054 each time i tried to move an existing forum or thread.
I read in similar threads that this is caused usually when not all of the upgrade files are installed correctly so i did a new upgrade this time upgrading to 4.1.5 but alas i have the same problem.
The error message is the following...
Database error in vBulletin 4.1.5:
Invalid SQL:
UPDATE forum SET
title_clean = 'Superleague 2010-11',
title = 'Superleague 2010-11',
description_clean = 'Η επιστροφή στην κορυφή...',
description = 'Η επιστροφή στην κορυφή...',
link = '',
displayorder = 1,
parentid = 59,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options - 256, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
ls_edit_ind = 0,
vsa_ap_viewforum = 0,
vsa_ap_viewthread = 0,
vsa_ap_postthread = 0,
vsa_ap_postreply = 0,
vsa_ap_viewlink = 0,
vsa_ap_postlink = 0
WHERE forumid = 93;
MySQL Error : Unknown column 'ls_edit_ind' in 'field list'
Error Number : 1054
Request Date : Friday, July 29th 2011 @ 05:22:51 PM
Error Date : Friday, July 29th 2011 @ 05:22:51 PM
Script : http://www.red-white.gr/forum/adminc....php?do=update
Referrer : http://www.red-white.gr/forum/adminc...p?do=edit&f=93
Invalid SQL:
UPDATE forum SET
title_clean = 'Superleague 2010-11',
title = 'Superleague 2010-11',
description_clean = 'Η επιστροφή στην κορυφή...',
description = 'Η επιστροφή στην κορυφή...',
link = '',
displayorder = 1,
parentid = 59,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options - 256, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
ls_edit_ind = 0,
vsa_ap_viewforum = 0,
vsa_ap_viewthread = 0,
vsa_ap_postthread = 0,
vsa_ap_postreply = 0,
vsa_ap_viewlink = 0,
vsa_ap_postlink = 0
WHERE forumid = 93;
MySQL Error : Unknown column 'ls_edit_ind' in 'field list'
Error Number : 1054
Request Date : Friday, July 29th 2011 @ 05:22:51 PM
Error Date : Friday, July 29th 2011 @ 05:22:51 PM
Script : http://www.red-white.gr/forum/adminc....php?do=update
Referrer : http://www.red-white.gr/forum/adminc...p?do=edit&f=93
Comment