Uninstall Script for 2.0 failing

Thanks for providing this script, but I am having problems with it. When running it to remove 2.0, I get

Parse error: parse error, unexpected T_STRING in /home/afr0chat/public_html/forums/admincp/uninstall_2_0.php on line 6

Line 6 is:
DROP TABLE " . TABLE_PREFIX . "articles_rating;

I need to uninstall so I can install from scratch.

[y2ksa]

come on please help on this one

[deb0]

yeah, I'm sendin out an SOS...!

[cinq]

So are the tables present in your DB b4 running this uninstall script ?

[mhme]

Database error in vBulletin 3.0.7:

Invalid SQL: DROP TABLE articles_rating
mysql error: Unknown table 'articles_rating'

mysql error number: 1051

Date: Saturday 02nd of April 2005 01:21:24 PM
Script: http://127.0.0.1/admincp/uninstall_2_0.php

[y2ksa]

this is what i get:

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE usergroup DROP 'vbarticlespermissions'
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 ''vbarticlespermissions'' at line 1

mysql error number: 1064

Date: Friday 01st of April 2005 06:07:14 AM
Script: http://www.mysite.com/vb/admincp/uninstall_2_0.php
Referer:
Username: y2ksa

[cinq]

Hmm just did a fresh install of v2.0 on a fresh install of vb3.0.7.
Proceeded to run the uninstall_2_0.php file.

Everything worked fine for me. ( had to edit the alter statement though, syntax error there, sorry )
I have a feeling some of you may have went into your db to drop tables manually and individually previously and didn't do a proper job of it, which is why the uninstall halts at some steps. If that is the case, you will need to comment out that particular line where the table is not found ( meaning it was somehow deleted previously )

[deb0]

Thanks for the info.

I tried this and was able to 'complete' the uninstall. Then when I go to install from scratch, it errors out when creating phrases:


Invalid SQL:
INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid)
VALUES (NULL, 0, 'vbart_backto', 'Back to', 1)

mysql error: Duplicate entry 'vbart_backto-0-1' for key 2

mysql error number: 1062

Date: Friday 01st of April 2005 11:13:44 AM
Script: http://www.xxx.net/forums/admincp/in...english&step=5
Referer: http://www.xxx.net/forums/admincp/in...english&step=4
Username: adminx
IP Address: x.x.x.x

There is a syntax in the removal script; make sure PHRASE is in lowercase letters.

Thanks for the help everyone!

[mhme]

Dear cinq,
I am waiting for your response. this is your script. you can help us.
https://vborg.vbsupport.ru/showpost....8&postcount=14

[cinq]

It works fine for me ...
Like i asked previously, is that table even present in your db ? ( use phpmyadmin to check first and report back ).

For that matter, check the other articles_ tables as well, see if they're there.

[y2ksa]

well did try every thing you wrote here and i still get the error did you fix the uninstall.php file?