mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
Hello :

We hosted around 20 phpfox script website on my server from over last year. from few days ago suddenly all phpfox scripts that hosted on our seerver face to problem , I was thinks this issue scripts related , but after invistigate I found server side problem , because when move same DB to other server , problem not occur .

Please help me , this is unknown issue , our mysql server version : 5.6.23
and this problem related innodb table . I checked database log and there are nothing !

possible reinstall mysql server ?

Thanks
 

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
No error ... some innodb table can't load from PHP .
table haven't any problem , when we move this database to another server , problem resolve.

Regards
 

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
because when new date submitted to database this data not loaded again ... but when you move this database to an other server this problem resolved . (only database moved , php file stay in same orginal server)

no error :
because check mysql logs
 

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
Are you sure the script can run properly on the version of MySQL you're running?
yes

Is the script up to date?
yes

Are the two servers running the same version of MySQL?

Yes
 

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
this is not related script , because when move to other server problem resolved.
also from today same problem occur in other system like WHMCS and ... in an other server with mysql 5.6
 

LostNerd

Well-Known Member
Mar 12, 2014
258
12
18
Hastings, East Sussex, UK
cPanel Access Level
Root Administrator
Twitter
This honestly sounds more likely to be an issue with the version of PHP you are currently running.

Are you able to create a file on the old server and the new one called "phpinfo.php" and copy this in to it:

Code:
<?php
phpinfo();
?>
Then, compare the version numbers of PHP and also copy the MySQL/MySQLi config parameters from both here for me?

I'll be happy to help if we can clarify the "error".
 

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
Thanks
Please attention , I move database to an other server and PHP file not moved and problem resolved.
So I think not related PHP or webserver .
 

LostNerd

Well-Known Member
Mar 12, 2014
258
12
18
Hastings, East Sussex, UK
cPanel Access Level
Root Administrator
Twitter
My apologies. That's what I get for skim-reading! Can you confirm that you have all required modules enabled in EasyApache? - It's possible that something is missing on the new server that just needs to be added.

You can download the EasyApache profile from your old server and import and build on the new one to get a near-perfect match.