vb.org Archive - vb 5.2 to vb 5,10

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB5 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=262)

- - vb 5.2 to vb 5,10 (https://vborg.vbsupport.ru/showthread.php?t=321540)

Hectorsky

01-19-2016 07:28 PM

vb 5.2 to vb 5,10

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

HTML Code:

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



                        Database error in vBulletin 5.2.0:



                        Invalid SQL:

INSERT  INTO widgetdefinition (`field`,`name`,`label`,`defaultvalue`,`isusereditable`,`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

01-19-2016 08:40 PM

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

Hectorsky

01-19-2016 08:49 PM

Quote:

Originally Posted by Dragonsys (Post 2562998)

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

01-19-2016 09:09 PM

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

Hectorsky

01-19-2016 09:16 PM

Quote:

Originally Posted by Zachery (Post 2563001)

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

01-20-2016 12:03 AM

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

Hectorsky

01-20-2016 05:52 AM

Quote:

Originally Posted by Zachery (Post 2563007)

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 [DATE]1453276589[/DATE] at [TIME]1453276589[/TIME] ---------------

i got this all the timev:

PHP Code:


		
			
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

01-20-2016 06:29 AM

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

01-20-2016 07:23 AM

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	01-20-2016 12:27 PM

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

01-20-2016 12:34 PM

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

01-20-2016 12:42 PM

Quote:

Originally Posted by DemOnstar (Post 2563029)

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	01-20-2016 12:45 PM

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

01-20-2016 12:53 PM

Quote:

Originally Posted by Dave (Post 2563031)

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

01-20-2016 01:03 PM

Quote:

Originally Posted by faustvasea97 (Post 2563030)

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

01-20-2016 01:04 PM

Quote:

Originally Posted by DemOnstar (Post 2563034)

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

01-20-2016 01:09 PM

Do you have cpanel on your server?

Hectorsky

01-20-2016 01:15 PM

Which ? I have phpadmin panel , and ovh cpanel

DemOnstar

01-20-2016 01:17 PM

Go to phpMyAdmin panel.

Hectorsky

01-20-2016 01:20 PM

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

01-20-2016 01:36 PM

1 Attachment(s)

My cpanel looks like this. . .

https://vborg.vbsupport.ru/attachmen...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/attachmen...1&d=1453303735

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

https://vborg.vbsupport.ru/attachmen...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

01-20-2016 01:37 PM

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 [DATE]1453304770[/DATE] at [TIME]1453304770[/TIME] ---------------

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

01-20-2016 01:59 PM

Quote:

Originally Posted by faustvasea97 (Post 2563043)

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 [DATE]1453305632[/DATE] at [TIME]1453305632[/TIME] ---------------

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

Hectorsky

01-20-2016 02:08 PM

Quote:

Originally Posted by DemOnstar (Post 2563047)

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

DemOnstar

01-20-2016 02:15 PM

Quote:

Originally Posted by faustvasea97 (Post 2563049)

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

01-20-2016 02:18 PM

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

--------------- Added [DATE]1453306903[/DATE] at [TIME]1453306903[/TIME] ---------------

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

DemOnstar

01-20-2016 02:30 PM

Quote:

Originally Posted by faustvasea97 (Post 2563052)

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

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

Quote:

Originally Posted by faustvasea97 (Post 2563052)

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

01-20-2016 02:38 PM

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

01-20-2016 02:45 PM

Quote:

Originally Posted by faustvasea97 (Post 2563056)

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

01-20-2016 04:04 PM

Quote:

Originally Posted by DemOnstar (Post 2563057)

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

01-20-2016 04:18 PM

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?

Hectorsky

01-20-2016 04:22 PM

Also , on importing db i got this issue :

PHP Code:


		
			
INSERT INTO `filedata` (`filedataid`, `userid`, `dateline`, `filedata`, `filesize`, `filehash`, `extension`, `refcount`, `width`, `height`, `publicview`) VALUES

(74, 1, 1449517799, 0x89504e470d0a1a0a0000000d49484452000002540000019c08060000001fcb3e6d000000017352474200aece1ce90000000467414d410000b18f0bfc6105000000097048597300000ec300000ec301c76fa8640000ffa549444154785eccfdf75f5469ba36f0f69f71ce3b33dd339d739b9124088a390ba282925444329224898839e7aca0e49c73ce399a73d6b6734f9ed9fb3ad7fdac5a5020f6f4cc7edffd393f5c9f55715580aaf5adfbb9d7b3def25e6b0ec9a63566f0723685e76a13ac5f39191e2ba6c0cd7e0a5c974f1e11b9ccdd416e63aab26195f9503c575b8c887ef93a4753de670ad62c190fa745e3b06afe575831f74bd8cffe02cb667d89c533bfc4c2195f609ecd67986df531ec2c3fc44c8b0f616bfa01f3216ca67e88e9261fc0dae47d584d790fd3184bc64262c2d353df5799c6db5b997d3422d6e61f639ac5c8589a7f3494d1d75931d6969f603a63c3d84efb1833e439597d04bb69f2bcf89cccde858de93b983ef51d3e1f2dd326bf0dcb496fc362c2db301bf71b4cfdeaffc0e4cbdfc0e48bdf60cae76f63f267bfc3844f7f8[...]

--------------- Added [DATE]1453314748[/DATE] at [TIME]1453314748[/TIME] ---------------

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 [DATE]1453319251[/DATE] at [TIME]1453319251[/TIME] ---------------

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

is redirecting me to install.php

--------------- Added [DATE]1453320068[/DATE] at [TIME]1453320068[/TIME] ---------------

Quote:

Originally Posted by shimei (Post 2563066)

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

01-20-2016 08:02 PM

Quote:

Originally Posted by DemOnstar (Post 2563089)

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

01-20-2016 08:13 PM

Quote:

Originally Posted by faustvasea97 (Post 2563090)

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

01-20-2016 08:21 PM

Quote:

Originally Posted by DemOnstar (Post 2563091)

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

01-20-2016 08:27 PM

Quote:

Originally Posted by faustvasea97 (Post 2563092)

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

01-20-2016 08:34 PM

Quote:

Originally Posted by DemOnstar (Post 2563093)

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

Dragonsys

01-20-2016 09:00 PM

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

01-20-2016 09:06 PM

Quote:

Originally Posted by Dragonsys (Post 2563096)

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

01-20-2016 09:07 PM

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

All times are GMT. The time now is 06:18 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02919 seconds Memory Usage 1,904KB 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 (1)bbcode_html_printable (2)bbcode_php_printable (21)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: