PDA

View Full Version : Vbulletin 4.2.5 Setup Error

tbellik
03-26-2019, 02:11 PM
Hi again.

I want to setup my forum again again and again but still I have problem during installation.

During the setup proccess after I enter admin name -password and mail address then I take this error. Please help me.

Vbulletin version is :4.2.5
Php version is : 7.0 but I tried 5.6 still same error.


Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<br />
<b>Warning</b>: mysqli_query(): (01000/1265): Data truncated for column 'datatype' at row 1 in <b>/storage/ssd2/650/8593650/public_html/includes/class_core.php</b> on line <b>1393</b><br />
<?xml version="1.0" encoding="windows-1252"?>
<errors>
<error><![CDATA[<p>Database Error</p>]]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.2.2</p>
<p>Invalid SQL:
REPLACE INTO setting
(product, varname, grouptitle, value, datatype, optioncode, volatile )VALUES('vbulletin', 'skimlinks_salt', 'version', '490159fbf13a4ed83e134fc99b003af1',
'', 'skimlinks', 1 );<p>
<p>
<strong>MySQL Error</strong> : Data truncated for column 'datatype' at row 1<br />
<strong>Error Number</strong> : 1265<br />
<strong>Request Date</strong> : Tuesday, March 26th 2019 @ 01:23:22 PM<br />
<strong>Error Date</strong> : Tuesday, March 26th 2019 @ 01:23:25 PM<br />
<strong>Script</strong> : http://defineyolu.club/install/install.php<br />
<strong>Referrer</strong> : http://defineyolu.club/install/install.php<br />
<strong>Classname</strong> : vB_Database_MySQLi<br />
<strong>MySQL Version</strong> : 10.3.13-MariaDB<br />
</p>]]></error_html>
</errors>
snakes1100
03-26-2019, 08:29 PM
1. import db backup via ssh
2. upload vb files via ftp to host
3. as it appears this is a vb 4.2.2 db, run the upgrade script hostname.com/forums/install/upgrade.php

There is no need to use the install script, as there is already a vb forum in that db.
tbellik
03-27-2019, 10:43 AM
1. import db backup via ssh
2. upload vb files via ftp to host
3. as it appears this is a vb 4.2.2 db, run the upgrade script hostname.com/forums/install/upgrade.php

There is no need to use the install script, as there is already a vb forum in that db.

I uploaded db via SSH , it is ok.

I want to move my forum hosting to another company hosting. So I copied my old files from root to new hosting root.

Then I copied 4.2.5 vb files to new root, and run the upgrade code . It gives an error.





I didnt start to install new host my vbulletin, is that problem ?

Is this compatible for vbulletin 4.2.5 installation ?

​​​​​​​
Apache Version 2.4.34
PHP Version 5.6.36
MySQL Version 5.6.39-cll-lve
snakes1100
03-28-2019, 07:43 AM
You didnt leave a clickable link in the last post, but it appears this link works fine.

https://www.bgobsession.com/showthread.php/124318-What-s-Your-NIGHTMARE-Draft-Scenario?p=369845#post369845

The versions you posted are compatible with 4.2.5
tbellik
03-28-2019, 09:15 AM
Now I see this error, after run upgrade command.

Warning: mysqli_query(): (01000/1265): Data truncated for column 'datatype' at row 1 in /storage/ssd2/650/8593650/public_html/includes/class_core.php on line 1393
snakes1100
03-28-2019, 05:45 PM
What command did you use to dump & import your db via ssh?
tbellik
03-29-2019, 06:11 AM
What command did you use to dump & import your db via ssh?

I did not db dump via ssh, I used cpanel, and just save sql file.

For import via ssh I used completely this code you see screenshot

https://vborg.vbsupport.ru/external/2019/03/3.png
snakes1100
03-29-2019, 07:45 AM
What screenshot?

How did you import db?
tbellik
03-29-2019, 09:43 AM
What screenshot?

How did you import db?

I imported with this code.

mysql -uusername -localhost -p

mysql>use username
mysql>source public_html/mybackupdb.sql
snakes1100
03-30-2019, 11:20 AM
Do a new dump of the DB from ssh

mysqldump --opt -uusername -p dbname > /path/to/save/backup.sql

transfer this new backup file to the new site & import it.

mysql -uusername -p dbname < /path/to/new/sql/backup.sql
tbellik
03-31-2019, 10:58 AM
Do a new dump of the DB from ssh

mysqldump --opt -uusername -p dbname > /path/to/save/backup.sql

transfer this new backup file to the new site & import it.

mysql -uusername -p dbname < /path/to/new/sql/backup.sql

Im using plesk panel and for export I used this code.

1 - Before I go in to sql -->

cd /var/lib/mysql


2 - And started this code

mysqldump --opt -Q -u define_yolvt -p define_yolvt > define_yolvt.sql


but didnt export it, after I enter password it is waiting 1 minute and then shows this code and nothing starts

[root@static-144-52 mysql]#
snakes1100
04-01-2019, 08:52 AM
After you enter the passwd, it shouldnt show anything while its dumping the db.

You can drop the Q flag in the dump cmd as well.

Did it create the file when you ran the cmd & is the file 0 in size?
tbellik
04-02-2019, 06:53 AM
After you enter the passwd, it shouldnt show anything while its dumping the db.

You can drop the Q flag in the dump cmd as well.

Did it create the file when you ran the cmd & is the file 0 in size?

Oy doesnt create any file.