[amity]

hi! i was helped by chen last evening, and now i have another question. my import of wwwthreads did not work- there was an error in the polls and now i must import all over again. i have taken the polls section out of the import script- and downloaded the sql query hack for my vb admin panel (since i cannot access this data base through mysql admin).

how would i go about deleting all information within a database? i don't want to delete the database itself. could someone tell me the query to run?

i apologize, i am not a programmer- i learn what i need as i go.

http://www.amitymama.com/vb/index.php?

these are my forums- i am almost done and would like to finish today.

thank you sooooo much in advance!!
always,
amity

[Chen]

Well basically to drop a table you do this:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

So type this as the query:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

This'll give you a list of all tables in the database. Then just type the DROP query for each one.

[amity]

when i put in the command
DROP access; (for example) i am getting this error message:
Database error in vBulletin Control Panel 2.2.3:

Invalid SQL: DROP access;
mysql error: You have an error in your SQL syntax near 'access' at line 1

mysql error number: 1064

Date: Saturday 09th of March 2002 09:42:06 PM
Script: http://amitymama.com/vb/vb/admin/query.php
Referer:
http://www.amitymama.com/vb/admin/query.php?t=0


i am sorry to bother you. i think i did the query the right way.

have a great evening... always
amity

[Chen]

Duh... it's DROP TABLE tblName;

[amity]

while i was deleting the tables, i received an error. so i decided to just upload the install and start over again.

i am about to do the import again- i took out the polls part of the script. i hope this works!!

thank you again chen. your username should be lifesaver... not firefly.

always,
amity

[amity]

okey dokey. it didn't work. i was getting a parse error. i will attach the full import script, and the part that i left out when i tried to run the script. i can't run the poll section of the import or i receive an error- so i need to import without it.

someone please help? pretty please?
always,
amity

this is the part i tried to delete and run...
attached is the whole script.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[TECK]

what is the parse error?
a little tip for you when you post the code: use [code] or [php] bbCodes to display your code in a elegant way.

regards,
nakkid.

[amity]

oh, i dunno. this is getting frustrating... really any ideas would be greatly appreciated.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[amity]

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

this should read

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

where should i change this?

maybe i am getting somewhere.
ugh
amity

[Chen]

Your problem is not with the script (which I removed from your first post, we don't allow to post full files of vBulletin).
It's with the database permissions, for some reason the user you are using can't access the 'amitysworld_com' database. Ask your host for more help.