Question How do I fix the database error?

Status
Not open for further replies.

pratul11

Member
Hi
I am getting the following error while installing DB Classifieds:

Database error in vBulletin 4.2.3:

Invalid SQL:

INSERT INTO `package` (`productid`, `class`)
VALUES ('dbtech_classifieds', 'DBTechClassifieds');;

MySQL Error : Duplicate entry 'DBTechClassifieds' for key 'class'
Error Number : 1062
Request Date : Thursday, January 12th 2017 @ 01:58:33 PM
Error Date : Thursday, January 12th 2017 @ 01:58:35 PM
Script : Log in - Occult Forums - Occult Forum - The Occult - Occult Symbols - Occult Books - vBulletin Admin Control Panel
Referrer : Log in - Occult Forums - Occult Forum - The Occult - Occult Symbols - Occult Books - vBulletin Admin Control Panel
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

Could you please help? Thanks
 
Have you tried installing Classifieds before? It looks like either a failed install or a previous install not uninstalled completely.
 
Mokonzi As the xml file was not getting uploaded properly, I had to try it again and again by selecting the overwrite option
 
no sorry...it was uploaded but did not install properly

What I mean is what stage of the install did it reach before it stopped progressing?

I can provide some uninstall code, but I think you'll find you end up with lots of issues. Do you want me to login for you and help clean it up? If so PM me some admin login details with permissions to run SQL queries, as well as add products.
 
Hi
it would be great if you could do the clean up..I will PM you the admin details with password within 5 minutes..thanks
 
Hi how is it going? Did you complete the cleanup? Mokonzi

I'm working on it at the moment. It looks like it's timing out before the install is completing. Do you have a shared server, or are you using VPS or dedicated? Can you adjust the timeout settings on the server in anyway?

PS, if you got any other MySQL errors in the last fifteen mins can you post them here for me?
 
Hi Mokonzi, thanks for your help. Yes, I am using GoDaddy shared hosting in Linux server. I didn't get any MySQL error as I haven't run any SQL query. I had installed many DBTech mods in my site and none of them caused me any serious installation problem except this one.
 
Hi Mokonzi, thanks for your help. Yes, I am using GoDaddy shared hosting in Linux server. I didn't get any MySQL error as I haven't run any SQL query. I had installed many DBTech mods in my site and none of them caused me any serious installation problem except this one.

I'll have another look at it this weekend and see if I can find a work around for you. :)
 
Hi Mokonzi I have increased the max execution time to 2048 M in PHP.ini file with the help of GoDaddy tech support. Could you please check now?
Thanks
 
Hi Mokonzi I have increased the max execution time to 2048 M in PHP.ini file with the help of GoDaddy tech support. Could you please check now?
Thanks

Thanks matey. I tried now and it's still not completing. Have the expanded the memory or the execution time? That figure of 2048 M looks like memory or max packet allcoation.
 
Status
Not open for further replies.

Legacy DragonByte Classifieds

vBulletin 4.x.x
Seller
Mokonzi
Release date
Last update
Total downloads
562
Customer rating
0.00 star(s) 0 ratings
Back
Top