vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vbArticles (https://vborg.vbsupport.ru/forumdisplay.php?f=106)
-   -   Uninstall Script for 2.0 failing (https://vborg.vbsupport.ru/showthread.php?t=78462)

deb0 03-20-2005 08:30 PM

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.

cinq 03-20-2005 11:01 PM

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

deb0 03-21-2005 02:10 AM

thanks for the folowup cinq

cinq 03-21-2005 03:10 AM

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

https://vborg.vbsupport.ru/showthrea...230#post627230

deb0 03-21-2005 03:17 AM

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/admin...nstall_2_0.php
Referer:
Username: xxxxx
IP Address: 68.209.120.165

y2ksa 03-21-2005 07:07 PM

same error here

y2ksa 03-26-2005 06:13 AM

any news about the Uninstaller?

deb0 03-26-2005 11:33 AM

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 03-26-2005 11:51 AM

Quote:

Originally Posted by 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/admin...nstall_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 03-28-2005 02:32 AM

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 03-31-2005 02:03 PM

come on please help on this one

deb0 04-01-2005 03:22 AM

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

cinq 04-01-2005 06:09 AM

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

mhme 04-01-2005 06:54 AM

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 04-01-2005 10:08 AM

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 04-01-2005 12:38 PM

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 04-01-2005 03:17 PM

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 04-02-2005 01:33 PM

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 04-02-2005 01:40 PM

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 04-02-2005 02:46 PM

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

mhme 04-04-2005 08:59 AM

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 04-04-2005 11:18 AM

Quote:

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 04-05-2005 01:40 AM

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 04-05-2005 01:47 AM

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


All times are GMT. The time now is 03:51 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01313 seconds
  • Memory Usage 1,763KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (24)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete