Big 4.0 upgrading issue!!

[jaredwilli]

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:

PHP Code:

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:

PHP Code:

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 [DATE]1261631907[/DATE] at [TIME]1261631907[/TIME] ---------------

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