Upgrade from 2.3.0 to 2.3.2 VIA code changes

This hack will allow you to upgrade your board from 2.3.0 to 2.3.2 by using code changes instead of over writing the files.


I will try and help support this hack, if you run into any problems come here and ask for help.


Notice: You still need to run upgrade.php!!

Be Sure to backup your files and database before applying the changes!

I take no responsobility for any damages!

This hack is ONLY for vBulletin 2.3.0!

There may be some mistakes in the file edits if you find any let me know ASAP so I can update the hack.

Possible a installed hack problem.

[squawell]

hello Hostc i got those error messages below:

PHP Code:

SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid= 
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 


PHP Code:

SQL: 
        SELECT
          post.postid, thread.visible
        FROM
          post LEFT JOIN thread ON thread.threadid=post.threadid
        WHERE
          post.visible=1 AND thread.visible=1 AND  1=1 AND post.userid='1451'
                    ORDER BY
          post.dateline DESC,post.dateline DESC
        LIMIT 0,25
        LIMIT 0, 25
        
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 25' at line 10 


how to fix that? thankz~

Originally Posted by squawell

hello Hostc i got those error messages below:

PHP Code:

SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid= 
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 


PHP Code:

SQL: 
SELECT
post.postid, thread.visible
FROM
post LEFT JOIN thread ON thread.threadid=post.threadid
WHERE
post.visible=1 AND thread.visible=1 AND 1=1 AND post.userid='1451'
ORDER BY
post.dateline DESC,post.dateline DESC
LIMIT 0,25
LIMIT 0, 25
 
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 25' at line 10 


how to fix that? thankz~

For the last one,

see the Limit 0, 25?

Take out the space before 25

[squawell]

Originally Posted by Hostc

For the last one,

see the Limit 0, 25?

Take out the space before 25

yes,i see that after i posted...i will try it and report here if it work~~

and the first one still need ur help thankz~~

[Airs]

Any idea about mine? the second one is in showthread.php and first one in memberlist.

[Private]

I couldn't find the hack in this thread, where is it?

<i>Last edited by Hostc on 09-27-03 at 08:10 AM. Reason: Hack is currently unstable</i>

[iggy123]

any chance of this getting any work done on it?

[MaDCaT75]

Is this hack worth it or not?