Vbulletin 4.2.5 Setup Error

[tbellik]

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]

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]

Originally Posted by snakes1100

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]

You didnt leave a clickable link in the last post, but it appears this link works fine.

https://www.bgobsession.com/showthre...845#post369845

The versions you posted are compatible with 4.2.5

[tbellik]

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]

What command did you use to dump & import your db via ssh?

[tbellik]

Originally Posted by snakes1100

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

[snakes1100]

What screenshot?

How did you import db?

[tbellik]

Originally Posted by snakes1100

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]

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