jaredwilli
12-24-2009, 02:49 AM
Ok so this is a bit of a mess. I wasn't sure what to do here so just go with it lol
I went to upgrade my forum from 3.8.3 to 4.0 and i uploaded all the files from the 4.0 and all that, started running the upgrade.php script, and then realized in the "readme.html" file for it it said i needed to FIRST upgrade to 3.8.4, which made me panic thinking i was gonna F someithing up, so I stopped the upgrader after it completed the step for whatever it did to album pictures, then downloaded-uploaded the 3.8.4 files, and went to the upgrade.php again, and thats when hell broke loose.
I have since been able to get my forum working again 'somewhat' by download/uploading the 3.8.2 files, i thought that's what version i had before but someone told me it was 3.8.3 a second ago.
So now my forum works, but I get database errors whenever things involving albums or the search function are attempted to be used.
The search mysql error is:
Invalid SQL:
SELECT searchid, dateline
FROM search AS search
WHERE userid = 1
ORDER BY dateline DESC LIMIT 1;
MySQL Error : Table 'my_dbname.search' doesn't exist
Script : http://tweeaks.com/forums/search.php?do=process
Referrer : http://tweeaks.com/forums/usercp.php
Album mysql error is:
Invalid SQL:
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
WHERE album.userid = 1
AND album.state IN ('public', 'private', 'profile')
ORDER BY album.lastpicturedate DESC
LIMIT 3;
MySQL Error : Table 'jaredwilli.picture' doesn't exist
Script : http://tweeaks.com/forums/member.php?u=1
Hopefully you won't laugh too hard, and will be able to tell me a quick and simple fix, and how to go about upgrading from here lol.
Let me know if I am forgetting any information needed to make a decision about what to do.
Thanks, and Happy Holidays!!
--------------- Added 1261631907 at 1261631907 ---------------
I'm finding more issues in the admincp too. like the admincp home page gets an error too.
Basically is there any way to just continue the 4.0 upgrade from where it left off, after completing the step for converting albums to attachments or whatever it did in that step?
I wish i just let it finish instead of stopping it ...
I went to upgrade my forum from 3.8.3 to 4.0 and i uploaded all the files from the 4.0 and all that, started running the upgrade.php script, and then realized in the "readme.html" file for it it said i needed to FIRST upgrade to 3.8.4, which made me panic thinking i was gonna F someithing up, so I stopped the upgrader after it completed the step for whatever it did to album pictures, then downloaded-uploaded the 3.8.4 files, and went to the upgrade.php again, and thats when hell broke loose.
I have since been able to get my forum working again 'somewhat' by download/uploading the 3.8.2 files, i thought that's what version i had before but someone told me it was 3.8.3 a second ago.
So now my forum works, but I get database errors whenever things involving albums or the search function are attempted to be used.
The search mysql error is:
Invalid SQL:
SELECT searchid, dateline
FROM search AS search
WHERE userid = 1
ORDER BY dateline DESC LIMIT 1;
MySQL Error : Table 'my_dbname.search' doesn't exist
Script : http://tweeaks.com/forums/search.php?do=process
Referrer : http://tweeaks.com/forums/usercp.php
Album mysql error is:
Invalid SQL:
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
WHERE album.userid = 1
AND album.state IN ('public', 'private', 'profile')
ORDER BY album.lastpicturedate DESC
LIMIT 3;
MySQL Error : Table 'jaredwilli.picture' doesn't exist
Script : http://tweeaks.com/forums/member.php?u=1
Hopefully you won't laugh too hard, and will be able to tell me a quick and simple fix, and how to go about upgrading from here lol.
Let me know if I am forgetting any information needed to make a decision about what to do.
Thanks, and Happy Holidays!!
--------------- Added 1261631907 at 1261631907 ---------------
I'm finding more issues in the admincp too. like the admincp home page gets an error too.
Basically is there any way to just continue the 4.0 upgrade from where it left off, after completing the step for converting albums to attachments or whatever it did in that step?
I wish i just let it finish instead of stopping it ...