vb 5.2 to vb 5,10

[Hectorsky]

I tried to install back vb 5.10 but I got again issue , wtf .

<?xml version="1.0" encoding="windows-1252"?>

Database error in vBulletin 5.2.0:

Invalid SQL:
INSERT INTO widgetdefinition (`field`,`name`,`label`,`defaultvalue`,`isuseredit able`,`isrequired`,`displayorder`,`validationtype` ,`widgetid`)
VALUES('YesNo','hide_title','Hide Title','1','1','0','5','force_datatype',1316)
/**widgetdefinition**/;

MySQL Error : Unknown column 'label' in 'field list'
Error Number : 1054
Request Date : Tuesday, January 19th 2016 @ 10:25:53 PM
Error Date : Tuesday, January 19th 2016 @ 10:25:54 PM
Script : http:///core/install/upgrade.php
Referrer : http://forum.republicamd.com/core/install/upgrade.php
IP Address : 141.0.14.72
Username :
Classname : vB_Database_MySQL
MySQL Version : 5.5.46-0+deb7u1-log


Stack Trace:
#line vB_Database->halt() called in [path]/vb/database.php on line 439
#line vB_Database->execute_query() called in [path]/vb/database.php on line 458
#line vB_Database->query_write() called in [path]/vb/db/query/insert.php on line 114
#line vB_dB_Query_Insert->doInserts() called in [path]/vb/db/query/insert.php on line 97
#line vB_dB_Query_Insert->execSQL() called in [path]/vb/db/assertor.php on line 282
#line vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 432
#line vB_dB_Assertor->insert() called in [path]/vb/xml/import/widget.php on line 108
#line vB_Xml_Import_Widget->import() called in [path]/vb/xml/import.php on line 155
#line vB_Xml_Import->importFromFile() called in [path]/install/includes/class_upgrade_final.php on line 174
#line vB_Upgrade_final->step_4() called in [path]/install/includes/class_upgrade.php on line 1704
#line vB_Upgrade_Version->execute_step() called in [path]/install/includes/class_upgrade_ajax.php on line 629
#line vB_Upgrade_Ajax->execute_step() called in [path]/install/includes/class_upgrade_ajax.php on line 413
#line vB_Upgrade_Ajax->process_step() called in [path]/install/includes/class_upgrade_ajax.php on line 148
#line vB_Upgrade_Ajax->init() called in [path]/install/includes/class_upgrade.php on line 538
#line vB_Upgrade_Abstract->__construct() called in [path]/install/includes/class_upgrade_ajax.php on line 80
#line vB_Upgrade_Ajax->__construct() called in [path]/install/includes/class_upgrade.php on line 49
#line vB_Upgrade::fetch_library() called in [path]/install/upgrade.php on line 98

#0 /home/surveyarns/www/forum/core/vb/database.php(439): vB_Database->halt()
#1 /home/surveyarns/www/forum/core/vb/database.php(458): vB_Database->execute_query(true, Resource id #24)
#2 /home/surveyarns/www/forum/core/vb/db/query/insert.php(114): vB_Database->query_write('INSERT INTO wi...')
#3 /home/surveyarns/www/forum/core/vb/db/query/insert.php(97): vB_dB_Query_Insert->doInserts()
#4 /home/surveyarns/www/forum/core/vb/db/assertor.php(282): vB_dB_Query_Insert->execSQL()
#5 /home/surveyarns/www/forum/core/vb/db/assertor.php(432): vB_dB_Assertor->assertQuery('widgetdefinitio...', Array)
#6 /home/surveyarns/www/forum/core/vb/xml/import/widget.php(108): vB_dB_Assertor->insert('widgetdefinitio...', Array)
#7 /home/surveyarns/www/forum/core/vb/xml/import.php(155): vB_Xml_Import_Widget->import()
#8 /home/surveyarns/www/forum/core/install/includes/class_upgrade_final.php(174): vB_Xml_Import->importFromFile('/home/surveyarn...')
#9 /home/surveyarns/www/forum/core/install/includes/class_upgrade.php(1704): vB_Upgrade_final->step_4(Array)
#10 /home/surveyarns/www/forum/core/install/includes/class_upgrade_ajax.php(629): vB_Upgrade_Version->execute_step(4, 1, Array)
#11 /home/surveyarns/www/forum/core/install/includes/class_upgrade_ajax.php(413): vB_Upgrade_Ajax->execute_step(4, 0, Object(vB_Upgrade_final), Object(vB_XML_Builder_Ajax), 1, NULL, 0, Array)
#12 /home/surveyarns/www/forum/core/install/includes/class_upgrade_ajax.php(148): vB_Upgrade_Ajax->process_step('final', 4, 0, 1, NULL, 0, 0, 0, Array)
#13 /home/surveyarns/www/forum/core/install/includes/class_upgrade.php(538): vB_Upgrade_Ajax->init(NULL)
#14 /home/surveyarns/www/forum/core/install/includes/class_upgrade_ajax.php(80): vB_Upgrade_Abstract->__construct(Object(vB_Registry), Array, 'upgrade')
#15 /home/surveyarns/www/forum/core/install/includes/class_upgrade.php(49): vB_Upgrade_Ajax->__construct(Object(vB_Registry), Array, 'upgrade', NULL, Array)
#16 /home/surveyarns/www/forum/core/install/upgrade.php(98): vB_Upgrade::fetch_library(Object(vB_Registry), Array, '', true)
#17 {main}
OK

Anyone know how I can fix that issues ?
Thanks

[Dragonsys]

You can't downgrade, you have to restore from the backup you made before attempting the upgrade (you did make a backup right?)

[Hectorsky]

You can't downgrade, you have to restore from the backup you made before attempting the upgrade (you did make a backup right?)

No , I didn't made backup , I still trying to upgrade 5.2 but nothing

[Zachery]

Then you should restore the 5.2.0 files and run the upgrade script.

[Hectorsky]

Then you should restore the 5.2.0 files and run the upgrade script.

What do you mean to restore , I even can't install that version , I got XML issue , and idk how to fix that one ..

[Zachery]

reupload all of the 5.2.0 files, run the upgrader again.

[Hectorsky]

reupload all of the 5.2.0 files, run the upgrader again.

Same issue , xml processing and upgrading is stop.... idk what's wrong with vb 5.2 version

--------------- Added 1453276589 at 1453276589 ---------------

i got this all the timev:

An error has occurred. Please contact vBulletin Support for assistance.

Module: final, Step 15 Error.

Failed to create default theme parent (readonly) style. If this is an upgrade, please ensure that upgrade step 520a3 completed.



Script: final
Step: 15

[DemOnstar]

Have you tried a fresh install rather than an upgrade?
Upload all the contents of the newer version into it's own folder, create a new database etc and go from the beginning to make a fresh install.

[Hectorsky]

I don't want to lose data,with my hosting I can have only one database . I made a ticket but there is no one answering to me .... and I'm getting mad. I don't know, I didn't had problems with upgrade on other versions... so I'm still waiting for some staff to answer on my ticket and to fix that issue...

[Dave]

It's going to be rather tricky to fix this since you first upgraded, then tried to downgrade and now try to upgrade again...

[DemOnstar]

Bit rubbish that your host only allows one database.
Anyway. . .

1. Copy your old database and download it from your site to your computer. (Keep it there.)
2. Create new database on your server for new install.
3. Do fresh install.
4. Delete all tables from new database and import the old database to new install.

Not sure if it is the best procedure but this is what I would have done in your case and may have to do myself if 5.2.0 is messy.

[Hectorsky]

Bit rubbish that your host only allows one database.
Anyway. . .

1. Copy your old database and download it from your site to your computer. (Keep it there.)
2. Create new database on your server for new install.
3. Do fresh install.
4. Delete all tables from new database and import the old database to new install.

Not sure if it is the best procedure but this is what I would have done in your case and may have to do myself if 5.2.0 is messy.

I don't have a lot of knowledge about database , so that's why I can't do that , I don't want to lose data . Still waiting for professional assistance from vbulletin staff team , but there are no answer, ,,, I think they answering when is about money... hope they will answer me and fix it today.

[Dave]

Well this is not really something vBulletin should fix for you. They can advice you but they are in no way obliged to help you out with this. Your best bet is to hire someone to fix this problem for you.

[Hectorsky]

Well this is not really something vBulletin should fix for you. They can advice you but they are in no way obliged to help you out with this. Your best bet is to hire someone to fix this problem for you.

Yes , but I'm still customer, so they should to provide some help , as I mentioned that is from new version issue. If they can't fix for me , is fine I'll fix , but IDK how .

[DemOnstar]

I don't have a lot of knowledge about database , so that's why I can't do that , I don't want to lose data . Still waiting for professional assistance from vbulletin staff team , but there are no answer, ,,, I think they answering when is about money... hope they will answer me and fix it today.

You don't need any knowledge. I don't have knowledge on database issues either.
It is all done from your server. cpanel takes you to php MyAdmin and all database creation and deleting, importing, copying etc is done from there. Even if you learn how to copy your database, you are already doing one of the most important tasks that you will need forever.

COPY your database and download it now!

[Hectorsky]

You don't need any knowledge. I don't have knowledge on database issues either.
It is all done from your server. cpanel takes you to php MyAdmin and all database creation and deleting, importing, copying etc is done from there. Even if you learn how to copy your database, you are already doing one of the most important tasks that you will need forever.

COPY your database and download it now!

Ok can you explain please how to do step by step ? BTW , if installation will gonna be successful and I will want to put old database, how can I do that ?

[DemOnstar]

Do you have cpanel on your server?

[Hectorsky]

Which ? I have phpadmin panel , and ovh cpanel

[DemOnstar]

Go to phpMyAdmin panel.

[Hectorsky]

ATM I'm at work, so I can't do anything now , but can you explain please step by step , hope I can fix that , as I see support from vbulletin is really badly.

[DemOnstar]

My cpanel looks like this. . .

https://vborg.vbsupport.ru/attachment.php?attachmentid=154048&stc=1&d=1453303317

You will find php MyAdmin on there and MySQL Databases.
To copy your database go to phpMyAdmin, select your databse from the pane on the right. You will see its name. Click on it and you will get a page that looks similar to this..

https://vborg.vbsupport.ru/attachment.php?attachmentid=154049&stc=1&d=1453303735

At the top you can see OPERATIONS.. Click on that..

https://vborg.vbsupport.ru/attachment.php?attachmentid=154050&stc=1&d=1453303917

Where it says 'copy database to' give your new database a name and click GO

Or as an alternative, instead of choosing OPERATIONS, you could choose EXPORT and do it that way instead.

[Hectorsky]

So just to be sure. I will make database backup now , than I will install new version of soft , and it will be clean forum , after I will need to delete all tables on new database and to import old one yea? But I will need to do again upgrade for that and it can be same issue ,.

--------------- Added 1453304770 at 1453304770 ---------------

I think it won't work, because I will make backup of trash database , so when I will do importing of old database it will request to do upgrade ,and I can have same issue.

[DemOnstar]

So just to be sure. I will make database backup now , than I will install new version of soft , and it will be clean forum , after I will need to delete all tables on new database and to import old one yea? But I will need to do again upgrade for that and it can be same issue ,.

1. Make back up yes. You should do this before any upgrade or before you test anything or do anything. Your database will hold everything you have done.

2. Create a new database, it should have the same name and username details as you have put in your config.php.

3. Run the install like you did when you made your first successful attempt.
http://yoursite/core/install/install.php or whatever.
Let the install do it's job. You might remember the page that tells you to remove the install folder before you go to admincp. Do that.

4. When complete, go to the database that has been newly created and delete all tables.

5. Then go to the IMPORT feature at the top of the page and import the database you safely copied and downloaded. Import it to the database you have deleted all tables from.

6. It might also be an idea to test the copied database for anything else?

From memory, this is the way I would do it. Make sure your config.php reflects the names and paswords etc. . . . .

If it fails, you have still achieved in learning how to do the most important maintenance task ever.
Copying your database for backup purposes.

Good luck..

--------------- Added 1453305632 at 1453305632 ---------------

If your database is trash then you have nothing to lose.
Just do the install and begin again with your newly gained advantage. . .

[Hectorsky]

1. Make back up yes. You should do this before any upgrade or before you test anything or do anything. Your database will hold everything you have done.

2. Create a new database, it should have the same name and username details as you have put in your config.php.

3. Run the install like you did when you made your first successful attempt.
http://yoursite/core/install/install.php or whatever.
Let the install do it's job. You might remember the page that tells you to remove the install folder before you go to admincp. Do that.

4. When complete, go to the database that has been newly created and delete all tables.

5. Then go to the IMPORT feature at the top of the page and import the database you safely copied and downloaded. Import it to the database you have deleted all tables from.

6. It might also be an idea to test the copied database for anything else?

From memory, this is the way I would do it. Make sure your config.php reflects the names and paswords etc. . . . .

If it fails, you have still achieved in learning how to do the most important maintenance task ever.
Copying your database for backup purposes.

Good luck..

--------------- Added 1453305632 at 1453305632 ---------------

If your database is trash then you have nothing to lose.
Just do the install and begin again with your newly gained advantage. . .

Yes , but I don't wanna lose data from my database...

[DemOnstar]

Yes , but I don't wanna lose data from my database...

But that is the whole point and why you are copying it!!! You are copying it so you don't lose it.
Then you say it is trash. So why copy trash?

[Hectorsky]

BTW , how I can remove table's from new database?

--------------- Added 1453306903 at 1453306903 ---------------

So in case if your suggestion doesn't work ,vbulletin supporting team , can restore everything and to fix that issue ?

[DemOnstar]

BTW , how I can remove table's from new database?

Scroll to the bottom of the table page. Click 'Check All' and select drop.

So in case if your suggestion doesn't work ,vbulletin supporting team , can restore everything and to fix that issue ?

They will hardly be able to fix your database or be willing to do that. .

[Hectorsky]

I will try to do that in couple of hours, I will answer here in both case if it was successfully or not . Thanks for help. Hope it will work.

[DemOnstar]

I will try to do that in couple of hours, I will answer here in both case if it was successfully or not . Thanks for help. Hope it will work.

Make sure you have a copy of your original database before doing anything. Whether it is trashed or not, get used to making database backups. They should be done regularly as a routine.

Never attempt to install mods or script edits until you have a copy of your database to fall back on.

[Hectorsky]

Make sure you have a copy of your original database before doing anything. Whether it is trashed or not, get used to making database backups. They should be done regularly as a routine.

Never attempt to install mods or script edits until you have a copy of your database to fall back on.

Step 1 - Connection successful
Table Conflict
Creating access table
An error has occurred with your database. Please contact vBulletin Support for assistance.

Module: install, Step 2 Database Error:1050

Table 'access' already exists

Query:

CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
nodeid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, nodeid)
) ENGINE = InnoDB

[shimei]

I have to say that the threads you have made here and in VB.com are the most painful reading I have done in some time. You have totally ignored the staff, and the basic procedures for making backups before any upgrade, and haven't an understanding on how to restore a backup when things go wrong.

Here's an articles to help:

MySQL Export: How to backup and restore your MySQL database? (https://www.siteground.com/tutorials/php-mysql/mysql_export.htm)

[Hectorsky]

Also , on importing db i got this issue :

INSERT INTO `filedata` (`filedataid`, `userid`, `dateline`, `filedata`, `filesize`, `filehash`, `extension`, `refcount`, `width`, `height`, `publicview`) VALUES
(74, 1, 1449517799, 0x89504e470d0a1a0a0000000d49484452000002540000019c 08060000001fcb3e6d000000017352474200aece1ce9000000 0467414d410000b18f0bfc6105000000097048597300000ec3 00000ec301c76fa8640000ffa549444154785eccfdf75f5469 ba36f0f69f71ce3b33dd339d739b9124088a390ba282925444 329224898839e7aca0e49c73ce399a73d6b6734f9ed9fb3ad7 fdac5a5020f6f4cc7edffd393f5c9f55715580aaf5adfbb9d7 b3def25e6b0ec9a63566f0723685e76a13ac5f39191e2ba6c0 cd7e0a5c974f1e11b9ccdd416e63aab26195f9503c575b8c88 7ef93a4753de670ad62c190fa745e3b06afe575831f74bd8cf fe02cb667d89c533bfc4c2195f609ecd67986df531ec2c3fc4 4c8b0f616bfa01f3216ca67e88e9261fc0dae47d584d790fd3 184bc64262c2d353df5799c6db5b997d3422d6e61f639ac5c8 589a7f3494d1d75931d6969f603a63c3d84efb1833e439597d 04bb69f2bcf89cccde858de93b983ef51d3e1f2dd326bf0dcb 496fc362c2db301bf71b4cfdeaffc0e4cbdfc0e48bdf60cae7 6f63f267bfc3844f7f8[...]

--------------- Added 1453314748 at 1453314748 ---------------

As I told before , there is something wrong with new version , so I fckt my forum with new version , other versions i did without any issues . And now I need to wait for them idk how long time...

--------------- Added 1453319251 at 1453319251 ---------------

Also , I'm not able to upgrade now my forum ....

is redirecting me to install.php

--------------- Added 1453320068 at 1453320068 ---------------

I have to say that the threads you have made here and in VB.com are the most painful reading I have done in some time. You have totally ignored the staff, and the basic procedures for making backups before any upgrade, and haven't an understanding on how to restore a backup when things go wrong.

Here's an articles to help:

MySQL Export: How to backup and restore your MySQL database? (https://www.siteground.com/tutorials/php-mysql/mysql_export.htm)

Why did you post that link , I got here an other issue for 1 day , fck cay , why i did this fcking vb 5.2 ,...

[Hectorsky]

What I described to you before is exactly how I resolved my issue with the database and upgrade nonsense.

I too have had so many failures with the software in the past I just gave up. I gave up on vb.com also.
Shabby is one way I would choose to describe it. . .
It isn't like it was before, the procedure of upgrading is not a guarantee. Best to test it first in a test environment before going to your live site. These are lessons you must learn from.

If I will loose data , there is no point to keep that lisence from vb , the issue is not from my side , I did upgrade as i did for other versions ,,, support is slow , and ticked for my lisence are useless , are giving to me url to some documents to read ....

[DemOnstar]

If I will loose data , there is no point to keep that lisence from vb , the issue is not from my side , I did upgrade as i did for other versions ,,, support is slow , and ticked for my lisence are useless , are giving to me url to some documents to read ....

I have seen how slow the support is.
You may also be correct in thinking that there is something wrong with 5.2.0. It wouldn't be the first bad release they have done. I downloaded it yesterday but haven't installed it yet. I always wait for a week or 2 before I install and even then, I do it on a test site.

I have been done numerous times before over this particular piece of software and it won't be happening to me again.

I paid for the license as you did but after all this time, I am now laughing at the whole experience.
It is just another example of what people can get away with selling in this world.

No point in being bitter, nothing concerning these people is going to change.

[Hectorsky]

I have seen how slow the support is.
You may also be correct in thinking that there is something wrong with 5.2.0. It wouldn't be the first bad release they have done. I downloaded it yesterday but haven't installed it yet. I always wait for a week or 2 before I install and even then, I do it on a test site.

I have been done numerous times before over this particular piece of software and it won't be happening to me again.

I paid for the license as you did but after all this time, I am now laughing at the whole experience.
It is just another example of what people can get away with selling in this world.

No point in being bitter, nothing concerning these people is going to change.

I will see . I'm just mad , I need to wait because they release shity version which fckt my forum and database , and now they doesn't want to help , idk how in how many days I will fix that ..... Your are lucky that didn't installed this shity version , I'm really dissapointed of support team and vbulletin soft...

I was work a lot on my forum , and I don't want to do it from 0 again...

[DemOnstar]

I will see . I'm just mad , I need to wait because they release shity version which fckt my forum and database , and now they doesn't want to help , idk how in how many days I will fix that ..... Your are lucky that didn't installed this shity version , I'm really dissapointed of support team and vbulletin soft...

I was work a lot on my forum , and I don't want to do it from 0 again...

You are not alone in this. Many people have been through the same shenanigans.
Learn form this as I and countless others have had to.
No point in talking about it much, it is generally not acceptable and heralds the closing of the topic.

You should make copies of all stuff you do, save it in a folder so you never lose it and remember to backup your database. Welcome to the system. . . .
Wish you well.

[Hectorsky]

You are not alone in this. Many people have been through the same shenanigans.
Learn form this as I and countless others have had to.
No point in talking about it much, it is generally not acceptable and heralds the closing of the topic.

You should make copies of all stuff you do, save it in a folder so you never lose it and remember to backup your database. Welcome to the system. . . .
Wish you well.

Yea , and now ? My forum still not fixed ,,,, and support team still doesn't answering to me ....

[Dragonsys]

I would look at the upgrade code and see what DB changes are made, then you can try to reverse those changes (manually). If you don't understand DB's and the coding you can ask for help (which you have been), if you need it ASAP, try asking in the paid forums.

You need to calm down and stop with the swearing though. Yes, your problem was caused by an issue in the upgrade, but it has been expanded by you not having a recent backup.

[Hectorsky]

I would look at the upgrade code and see what DB changes are made, then you can try to reverse those changes (manually). If you don't understand DB's and the coding you can ask for help (which you have been), if you need it ASAP, try asking in the paid forums.

You need to calm down and stop with the swearing though. Yes, your problem was caused by an issue in the upgrade, but it has been expanded by you not having a recent backup.

I will not gonna pay for things which are not cause by me ... There is version vb 5.2 , and I should to get support to get fix that issue , . So you can help me to fix that issue?

How to calm down when my forum is crashed and there is not one who can help me to get my issue fixed , already paste 1 day ,

[Zachery]

If you want official support, you should post on vBulletin.com, or open a ticket in the members area.

[Hectorsky]

If you want official support, you should post on vBulletin.com, or open a ticket in the members area.

With my license I can't get support by ticket . On vbulletin.com already did , But i think they don't know as well how to fix that issue .. so I'm understanding why did they release new version if they didn't test it properly ... I'm not professional like them to fix any issue which I will get with new version...

[Dragonsys]

I will not gonna pay for things which are not cause by me ... There is version vb 5.2 , and I should to get support to get fix that issue , . So you can help me to fix that issue?

How to calm down when my forum is crashed and there is not one who can help me to get my issue fixed , already paste 1 day ,

You obviously did not read/understand what I actually posted... so let me put this another way.

This site is not a Support for vBulletin, we are volunteers who do not get paid by vBulletin. We also cannot help that you neglected to take a backup before trying to upgrade your forums, or that you do not have any recent backups (which I am assuming based n your posts). So, you want us to fix it ASAP then you need to ask nicely and possibly pay. You want vBulletin to fix it for free, you need to keep posting on vb.com and wait for them. Coming on here and being all pissy and swearing in almost every post isn't going to get you anywhere. Ultimately, this (website down/possible lost data) is your fault for not having backups. If you don't know how to take backups of your website & DB's, maybe you should pay for Webmaster services.

That said, good luck, I hope you get it fixed.

[Hectorsky]

You obviously did not read/understand what I actually posted... so let me put this another way.

This site is not a Support for vBulletin, we are volunteers who do not get paid by vBulletin. We also cannot help that you neglected to take a backup before trying to upgrade your forums, or that you do not have any recent backups (which I am assuming based n your posts). So, you want us to fix it ASAP then you need to ask nicely and possibly pay. You want vBulletin to fix it for free, you need to keep posting on vb.com and wait for them. Coming on here and being all pissy and swearing in almost every post isn't going to get you anywhere. Ultimately, this (website down/possible lost data) is your fault for not having backups. If you don't know how to take backups of your website & DB's, maybe you should pay for Webmaster services.

That said, good luck, I hope you get it fixed.

i made a back up . and If issue wasn't made from version vb , I can pay , but there is issue from version , I will not may any pence for that , I did upgrade , as I did for other versions vbulletin.

[Dragonsys]

i made a back up . and If issue wasn't made from version vb , I can pay , but there is issue from version , I will not may any pence for that , I did upgrade , as I did for other versions vbulletin.

No, you made a backup after the fact, after the damage was already done. Just because you didn't have problems before, doesn't mean you won't the next time. Never assume things will work, always assume they won't and prepare for it.


I'm not saying you have to pay to get this fixed. I'm saying if you don't want to pay, then you must wait.

[Hectorsky]

So if I will pay for professional upgrade, they will fix that database and issues without loosing any data from there?

[DemOnstar]

So if I will pay for professional upgrade, they will fix that database and issues without loosing any data from there?

It might be a good idea to direct that question to the people themselves.. But be patient when waiting for a response. . . .
You should understand the drill by now. :o

[Hectorsky]

It might be a good idea to direct that question to the people themselves.. But be patient when waiting for a response. . . .
You should understand the drill by now. :o

Already asking them , so still waiting for answer...

[Mark.B]

I think I need to clear some of this up.

You posted in the support forum asking for help. You then kept bumping the thread demanding answers, often only minutes after your initial request. When you didn't get immediate assistance, you went off and tried to fix your site by trying to restore files from 5.1.10 and running the upgrade script. This messed up your database, and you didn't have a backup.

At some point you also deleted your database and then restored back from a corrupted copy taken after the upgrade, which made things even worse.

Despite this, I offered to try to fix the site up, but it wasn't possible to do. I did however, recover the memberlist. I then offered to install a new copy of the forum for you, and attempt to import that memberlist. This took some time as you had installed add ons so the user table had more columns than the default, meaning I had to do a lot of playing about with it. I was about an hour into sorting this when you deleted the database again rendering my work useless.

Your account doesn't have ticket support, despite this I personally put in several hours of work free of charge to try and get at least part of your site back online, only for you to delete the database while I was in the middle of doing it, which you then said was because I wasn't replying to your ticket. Of course I wasn't, I was frantically trying to get what I could of your site back online.

Our reward for this was you turning up on the support forum swearing all over the place. Swearing, or circumventing the swear filter, is against the rules in the support forums and normally leads to a ban of some sort. One of my colleagues rightly picked this up and closed the thread after warning you to moderate the language. We're not here to be sworn at and abused. End of story.

You need to be patient with support requests. vBulletin has thousands of customers and a limited number of support staff. We are not just sitting around watching the forums or the ticket system in case someone posts something, we are busy working on other customer issues. We are most likely working on several different customers at any one time. We cannot drop what we are doing in order to assist a specific customer.

Additionally, all tickets and forum posts are dealt with in time order - the ones with the oldest last reply get picked up first. So if you keep posting "Why no answer?" in your ticket or thread, all you will actually do is delay any response you receive. Especially when the support person isn't replying because he's busy working on YOUR site! If you've gone 48 hours with no reply, by all means give it a bump, but not before.

In short:
1. There is no problem with 5.2.0. I've installed and upgraded loads of sites already, including my own demo site, with no issue.
2. And this is the important one. If something does go wrong on an upgrade (or anything else), please post for support and then WAIT. Don't decide after ten minutes that you're going to rush off and try and fix it yourself. You will almost certainly break your site and you may end up in a position like this where even support cannot recover it.
3. Don't shout and swear at the support staff of ANY company. They are trying to help you.
4. Never, ever, ever perform an upgrade without a FULL backup of the ENTIRE database and files. If you have that, then no matter bad things get we can always bring your site back for you. Without it, both you and us are screwed.

[shimei]

Our reward for this was you turning up on the support forum swearing all over the place and demanding somebody "does something". Swearing, or circumventing the swear filter, is against the rules in the support forums and normally leads to a ban of some sort. One of my colleagues rightly picked this up and closed the thread after warning you to moderate the language. We're not here to be sworn at and abused. End of story.


I must say, after reading all the posts and threads here in VB.org and VB.com that the patience of staff went to such an extent that some respect was lost. That kind of behavior shouldn't be tolerated. I would commend VB staff for bending over backwards in assisting another, but not at the expense of subjecting other members to these kind of tantrums and vulgar language. Obviously, your efforts were without gratitude, a testimony about faustvasea97.

[Mark.B]

I must say, after reading all the posts and threads here in VB.org and VB.com that the patience of staff went to such an extent that some respect was lost. That kind of behavior shouldn't be tolerated. I would commend VB staff for bending over backwards in assisting another, but not at the expense of subjecting other members to these kind of tantrums and vulgar language. Obviously, your efforts were without gratitude, a testimony about faustvasea97.
You are right of course.

That said, the support team are all forum owners ourselves, and we feel the pain of people who lose their sites. In this case, I was personally quite upset when we realised the database was beyond fixing and the customer had no backup. It's probably also why the customer wasn't issued with a temporary ban for the swearing, because we do have a great deal of sympathy. Nobody sets out to intentionally wreck their site, this was really caused by over exuberance and and perhaps a touch of panic. Always makes things worse. :(

Had the customer had a backup I would have restored the site back to 5.1.10 and performed the upgrade to 5.2.0 at no cost, to get out of the hole the customer was in with minimum fuss.

Sadly the grand lesson from this is really the same as it's lways been...BACKUP. BACKUP. BACKUP.

With a backup, in theory it doesn't matter how much of a mess anyone makes, we can always roll it all back.

I haven't enjoyed this particular case at all, I'm afraid to say. :(