Problem with phpfox script
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
-
I even reinstall mysql ... but not issue resolved 0 -
What is the issue, or error? 0 -
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 0 -
Try WHM >> SQL Services >> Repair a MySQL Database. 0 -
not help us this method 0 -
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
How do you know this if there is no error? The site just doesn't load? More Info needed here I think.0 -
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 0 -
Are you sure the script can run properly on the version of MySQL you're running? Is the script up to date? Are the two servers running the same version of MySQL? 0 -
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 0 -
You might want to ask about this over on the support site for the script, then. 0 -
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 0 -
5.3 0 -
So, whats the differences between the 2 servers then? 0 -
Downgrading is not supported by cPanel I don't think. That post is from 2009. Feel free to hang on a bit longer until someone comes by that can properly answer you about this. 0 -
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:
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".0 -
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 . 0 -
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. 0 -
new server use as remote-mysql server and php used same old server . 0 -
Hello, The following thread may help if there is InnoDB corruption as you suggested: InnoDB Repair Guide Thank you. 0 -
data not losed ... data exist and tables accessible from phpmyadmin . but not loaded from database to php engine . 0 -
...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
Do you recall any updates you did a few days ago by chance? It might be helpful. In the meantime, you might consider looking for some assistance with your scripts issues. This thread is 2 pages long and we're no closer to understanding what the reason for this issue is still.0 -
1. few weeks ago we upgrade mysql server from 5.5 to 5.6 2. on 1st server few days ago (5May) I reboot mysql server, after this customer reported that some database data table not load to their site . (mostly phpfox - also few in other scripts) 3. I was reinstall mysql - disable cloudlinux - cagefs ... but problem not resolve. also rebuild php 4. after above, I move that database to remote-mysql-test-server with same Mysql version (5.6) and problem resolved. So I found this problem mysql related 5. yesterday in an other server like above (server B - that mysql upgraded from 5.5 - 5.6 few weeks ago) when mysql server restart, same problem occurred . for example when I answer ticket (WHMCS), this date not submitted to ticket ... some clients can't update their site . few website error like this : SQL] [1364] Field 'stat_time' doesn't have a default value STRING: INSERT INTO pn_statistics (`stat_name`,`stat_value`) VALUES ('Day-1394-02-24','0') also in this server when I move database to remote-mysql-test-server this problem resolved. 6. I speak with few system admin and they can't find my issue . Regards 0 -
. yesterday in an other server like above (server B - that mysql upgraded from 5.5 - 5.6 few weeks ago) when mysql server restart, same problem occurred . for example when I answer ticket (WHMCS)
If I was to guess, it sounds to me like your server is running newer versions of PHP and MySQL than your scripts wants to run on.SQL] [1364] Field 'stat_time' doesn't have a default value
Not sure how helpful this is, but have a read of this post that mentions that error: stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values0 -
Hi : Resolved PROBLEM I think your problem stems from a change in sql_mode. [LIST] - sql_mode is blank in MySQL 5.5
- It is not blank in MySQL 5.6 SOLUTION Run this command SET GLOBAL sql_mode =''; Then, add this to my.cnf to keep sql_mode blank should you restart mysqld [mysqld] sql_mode ='' You do not need to restart mysqld since you set it globally
0 -
I am happy to see the issue is now resolved. Thank you for updating us with the outcome. 0
Please sign in to leave a comment.
Comments
27 comments