Uninstall Script for 2.0 failing

[deb0]

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.

[cinq]

Will look into it this evening and keep you updated.
I think I did something stupid in the uninstall script :D

[deb0]

thanks for the folowup cinq

[cinq]

Could you try download the attachment again and trying it out.
Let me know if it works this time.

https://vborg.vbsupport.ru/showthread.php?p=627230#post627230

[deb0]

I get the following error:

Database error in vBulletin 3.0.6:

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

mysql error number: 1051

Date: Sunday 20th of March 2005 11:16:01 PM
Script: http://www.afrochat.net/forums/admincp/uninstall_2_0.php
Referer:
Username: xxxxx
IP Address: 68.209.120.165

[y2ksa]

same error here

[y2ksa]

any news about the Uninstaller?

[deb0]

Yeah, me too. My members are threatening a revolt if I don't get this up. I got it working on my dev site and it's the best I've seen so far.

[Moncal]

I get the following error:

Database error in vBulletin 3.0.6:

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

mysql error number: 1051

Date: Sunday 20th of March 2005 11:16:01 PM
Script: http://www.afrochat.net/forums/admincp/uninstall_2_0.php
Referer:
Username: xxxxx
IP Address: 68.209.120.165
Have you used phpmyadmin or a similar program to verify that the table exists in your database?
It's possible that during installation the querie didn't run properly to create the table.

[deb0]

If it finds the table, it halts with an error. I have to go in manually and remove EVERY table. If I miss one, I have to start over. I am waiting on the coder to correct his uninstall script and resubmit so I can remove and start over.

[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/install_vbarticles.php?hacklanguage=english&step=5
Referer: http://www.xxx.net/forums/admincp/install_vbarticles.php?hacklanguage=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.php?p=634228&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?

[mhme]

There is tables in vB database.
Anyway, please let me to have an uninstall script just to remove phraces and styles of vbArticles.
I will remove tables from db handy. (via phpMyAdmin)

I am waiting for your reply.

Thanks a lot.

[n1ckn4me]

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. I think cinq is looking for a yes or a no...

[mhme]

YES
This is list of my tables (phpMyAdmin)
access
adminhelp
administrator
adminlog
adminutil
announcement
article
articleattachment
articlecategory
articlepost
articlerating
attachment
attachmenttype
attachmentviews
avatar
bbcode
calendar
calendarcustomfield
calendarmoderator
calendarpermission
cpsession
cron
cronlog
customavatar
customprofilepic
datastore
deletionlog
editlog
event
faq
forum
forumpermission
holiday
icon
imagecategory
imagecategorypermission
language
mailqueue
moderation
moderator
moderatorlog
passwordhistory
phrase
phrasetype
pm
pmreceipt
pmtext
poll
pollvote
post
post_parsed
posthash
postindex
profilefield
ranks
regimage
reminder
reputation
reputationlevel
search
session
setting
settinggroup
smilie
stats
strikes
style
subscribeevent
subscribeforum
subscribethread
subscription
subscriptionlog
template
thread
threadrate
threadviews
upgradelog
user
useractivation
userban
userfield
usergroup
usergroupleader
usergrouprequest
usernote
userpromotion
usertextfield
usertitle
vbindex_shoutbox
word

[cinq]

That isn't my hack, you're in the wrong forum :)