Teck: Because I've never run into a problem like this before. I currently have 60 hacks running on my board - I can handle that, but I'm not too hot with SQL.
NTLDR: It did run correctly, I checked in phpMyAdmin.
I do though have the same problem as Satan had earlier, where no news text is shown on OLD news posts, I made a new one to test and it all appears correctly. I ran the script you posted
here in the admin folder, it seemed to process some posts but then I got the following SQL error.
Quote:
Invalid SQL: UPDATE thread SET tpostid= WHERE threadid=34
mysql error: You have an error in your SQL syntax near 'WHERE threadid=34' at line 1
mysql error number: 1064
|
Also, when I tried to post something in the Shoutbox on the vBindex page, it tries to go to a page named vbibeta.php. I resolved this by replacing vbibeta.php with $bburl/shoutbox.php in the home_postshout template. But how do I make the vBindex come back to the main page after a shout is posted? The smilies in the vBindex Shoutbox also don't use the correct URL so none of them show up.
It might also be a good idea to state in the instructions that people using vBindex outside of the forums folder shout change their' imagesfolder replacement to the full URL [this doesn't though, fix the Shoutbox smilie problem].