Question reinstalling after crash over previously installed

Status
Not open for further replies.

IggyP

New member
hello :)

i have a question about reinstalling after a server crash....which had a restore made to before the product was installed...

i believe the tables have been removed but i have noticed at least this one error i dont understand..

and another in vb credits which crashed the site completely trying to reupload the xml...

i figure its a common solution to clear those old traces out procedure?

PHP Warning: mysqli_query(): (23000/1062): Duplicate entry 'DBTechClassifieds' for key 'class' in ..../includes/class_core.php on line 1394
 
That error is most likely referring to the contenttype database table, if you remove it from there you should be able to reinstall :)
 
hello :)

i have a question about reinstalling after a server crash....which had a restore made to before the product was installed...

i believe the tables have been removed but i have noticed at least this one error i dont understand..

and another in vb credits which crashed the site completely trying to reupload the xml...

i figure its a common solution to clear those old traces out procedure?

PHP Warning: mysqli_query(): (23000/1062): Duplicate entry 'DBTechClassifieds' for key 'class' in ..../includes/class_core.php on line 1394

I think Fillip H. has it right. If you have a problem doing it, I'll help out if you need. :)

It does puzzle me that they've restored something from before you installed Classifieds, if they did you shouldn't have a duplicate key entry... it would not have been inserted from the time of the restore. :D
 
ok contenttype was deleted but we got the same error....checked again and verified no old classifieds tables...hmm
 
still didnt figure this out...didnt even try to reinstall credits again as that one also broke the site....

perhaps someone can help by answering a question of what i was intending to test....


is it possible to integrate this with vbcredits to make a "points/credits store"?
we dont want to use any real currencies just a simple points or credits for real products type model...
 
hmm that actually broke the site....

ok contenttype was deleted but we got the same error....checked again and verified no old classifieds tables...hmm

If you deleted the whole table, that wasn't what we were suggesting... you need the table generally. But you needed to remove the Classifieds entry only. I'll check the exact command for you shortly.

still didnt figure this out...didnt even try to reinstall credits again as that one also broke the site....

perhaps someone can help by answering a question of what i was intending to test....


is it possible to integrate this with vbcredits to make a "points/credits store"?
we dont want to use any real currencies just a simple points or credits for real products type model...

vBCredits questions need to be in the vBCredits forums as I don't look after that product :)
 
well...its a question of if 2 products can integrate to do that or not.....with the other product being this one....i dont see the difference of starting another topic?

im not trying to trouble shoot vbcredits reinstall right now... since there is an issue to even install these 2 products atm i ask if the creators/community/support knows if that basic integration is possible...if not there is no point to make such a trouble to install them, see what i mean?
 
well...its a question of if 2 products can integrate to do that or not.....with the other product being this one....i dont see the difference of starting another topic?

im not trying to trouble shoot vbcredits reinstall right now... since there is an issue to even install these 2 products atm i ask if the creators/community/support knows if that basic integration is possible...if not there is no point to make such a trouble to install them, see what i mean?

The two mods are not related, and the developer of vBCredits isn't me. The issue might be the same, or it might be different. Even if it is the same, the solution to fix it might not be one I can give you.

It's our process to keep things separate and we can always cross link threads so we know they are similar or might be related.

Regarding integration, I'm not sure. I've not tried it yet with vBCredits, though it might well be possible. This thread was originally about the crash issue. Has that been fixed yet or not?

In the following SQL code snippets, replace the TABLE_PREFIX with whatever you have in your config settings. Run this SQL first to get an ID number
Code:
	SELECT 
		p.packageid
	FROM `TABLE_PREFIXpackage` AS p
	WHERE `productid` = 'dbtech_classifieds';

Then replace the YourPackageID with that ID number

Code:
	DELETE FROM `TABLE_PREFIX	contenttype`  
	WHERE `class` = 'Listing'
	OR `class` = 'Shop' 
	AND `packageid` = YourPackageID

You'll need to run this to help reset the system.

Code:
	DELETE FROM `TABLE_PREFIXpackage`  
	WHERE `productid` = 'dbtech_classifieds'

I'll reiterate my concerns that if you've done a restore on your SQL database and are having these issues, then it was restored with Classifieds installed. That being the case you might need to look at whether you have the files for the mod uploaded. If so, that might be all the fix you need. If it was restored to before the Classified was installed, check to see if you have the Classifieds files on the server, as that could be part of the problem too.

Let me know how you're getting on and keep me posted on things. :)
 
unfortunately im positive that the restore version did not have the product installed...there is about a month time between the 2 events so i am def certain of this...

we can try the query tho and hope that helps...it is very strange indeed....i did a comparison on another server where it has phpmyadmin and this product installed and looked very closely over everything that has been mentioned, but still didnt see anything that made sense...like contenttype or blah etc idk...

he wants to enable bitcoin anyway so perhaps it just needs to wait on the next version and will work fine? either way something not right with that so we will keep invesigating, thank you for the information
 
unfortunately im positive that the restore version did not have the product installed...there is about a month time between the 2 events so i am def certain of this...

we can try the query tho and hope that helps...it is very strange indeed....i did a comparison on another server where it has phpmyadmin and this product installed and looked very closely over everything that has been mentioned, but still didnt see anything that made sense...like contenttype or blah etc idk...

he wants to enable bitcoin anyway so perhaps it just needs to wait on the next version and will work fine? either way something not right with that so we will keep invesigating, thank you for the information

Anymore news?
 
yes he did get it working thank you to folllow up....some of those query gave him error but it was enough that he eventually figured it out one way or other....i can ask back if you are interested of more specific infos....

i think we are just waiting on v2 now :)
 
yes he did get it working thank you to folllow up....some of those query gave him error but it was enough that he eventually figured it out one way or other....i can ask back if you are interested of more specific infos....

i think we are just waiting on v2 now :)

That could be useful. :)
 
Hello IggyP,

This ticket has now been closed with the status Answered.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!
 
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