vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Vbulletin 4.2.5 Setup Error (https://vborg.vbsupport.ru/showthread.php?t=327167)

tbellik 03-26-2019 02:11 PM
Vbulletin 4.2.5 Setup Error
 
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.


Code:
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
Quote:
Originally Posted by snakes1100 (Post 2598884)
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/showthre...845#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
Quote:
Originally Posted by snakes1100 (Post 2598900)
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
Quote:
Originally Posted by snakes1100 (Post 2598907)
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
Quote:
Originally Posted by snakes1100 (Post 2598913)
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 -->

Code:
cd /var/lib/mysql

2 - And started this code

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

Code:
[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
Quote:
Originally Posted by snakes1100 (Post 2598931)
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.


All times are GMT. The time now is 11:55 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01057 seconds
  • Memory Usage 1,748KB
  • 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
  • (4)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (13)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete