oc database errors/mismatch
Posted: Fri Sep 30, 2022 10:07 am
Hi,
Today I started getting some errors pop up on my oc website & admin pages....
First error on page states:
Warning: mysqli::__construct(): Headers and client library minor version mismatch. Headers:100608 Library:30302 in /home/redacted/shop.indonesianwholesaler.com/system/library/db/mysqli.php on line 7
Second pop up window error in admin states:
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: mysqli::__construct(): Headers and client library minor version mismatch. Headers:100608 Library:30302 in <b>/home/redacted/shop.indonesianwholesaler.com/system/library/db/mysqli.php</b> on line <b>7</b>{"order":{"label":"Orders","data":[[1,0],[2,0],[3,0],[4,0],[5,0],[6,0],[7,0],[8,0],[9,0],[10,0],[11,0],[12,0],[13,0],[14,0],[15,0],[16,0],[17,0],[18,0],[19,0],[20,0],[21,0],[22,0],[23,0],[24,0],[25,0],[26,0],[27,0],[28,0],[29,0],[30,0]]},"customer":{"label":"Customers","data":[[1,0],[2,0],[3,0],[4,0],[5,"1"],[6,0],[7,0],[8,0],[9,0],[10,"2"],[11,0],[12,0],[13,0],[14,0],[15,0],[16,0],[17,0],[18,"1"],[19,0],[20,0],[21,"1"],[22,0],[23,0],[24,0],[25,"1"],[26,"1"],[27,0],[28,0],[29,"1"],[30,0]]},"xaxis":[["1","01"],["2","02"],["3","03"],["4","04"],["5","05"],["6","06"],["7","07"],["8","08"],["9","09"],["10","10"],["11","11"],["12","12"],["13","13"],["14","14"],["15","15"],["16","16"],["17","17"],["18","18"],["19","19"],["20","20"],["21","21"],["22","22"],["23","23"],["24","24"],["25","25"],["26","26"],["27","27"],["28","28"],["29","29"],["30","30"]]}
Third pop up window error in admin states:
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: mysqli::__construct(): Headers and client library minor version mismatch. Headers:100608 Library:30302 in <b>/home/redacted/shop.indonesianwholesaler.com/system/library/db/mysqli.php</b> on line <b>7</b>{"nl":{"total":"1","amount":"7,930,000 Rp"},"ae":{"total":"1","amount":"1,605,000 Rp"},"gb":{"total":"5","amount":"38,970,000 Rp"},"vn":{"total":"1","amount":"4,295,000 Rp"}}
So I'm currently looking around at the db data & php files, but not sure exactly what's happened...I currently can't change/save any store settings in admin to stop the errors from showing on the live site. I found some currency symbols had become corrupted/changed & I was able to change & save those ok within the admin pages. Some data isn't displaying as well on the admin home page dashboard (map/sales analytics). I'll keep investigating further, but thought I'd ask/see if anyone knows what might have caused this to happen overnight & if there's any known solutions. Thanks in advance for any input.
Today I started getting some errors pop up on my oc website & admin pages....
First error on page states:
Warning: mysqli::__construct(): Headers and client library minor version mismatch. Headers:100608 Library:30302 in /home/redacted/shop.indonesianwholesaler.com/system/library/db/mysqli.php on line 7
Second pop up window error in admin states:
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: mysqli::__construct(): Headers and client library minor version mismatch. Headers:100608 Library:30302 in <b>/home/redacted/shop.indonesianwholesaler.com/system/library/db/mysqli.php</b> on line <b>7</b>{"order":{"label":"Orders","data":[[1,0],[2,0],[3,0],[4,0],[5,0],[6,0],[7,0],[8,0],[9,0],[10,0],[11,0],[12,0],[13,0],[14,0],[15,0],[16,0],[17,0],[18,0],[19,0],[20,0],[21,0],[22,0],[23,0],[24,0],[25,0],[26,0],[27,0],[28,0],[29,0],[30,0]]},"customer":{"label":"Customers","data":[[1,0],[2,0],[3,0],[4,0],[5,"1"],[6,0],[7,0],[8,0],[9,0],[10,"2"],[11,0],[12,0],[13,0],[14,0],[15,0],[16,0],[17,0],[18,"1"],[19,0],[20,0],[21,"1"],[22,0],[23,0],[24,0],[25,"1"],[26,"1"],[27,0],[28,0],[29,"1"],[30,0]]},"xaxis":[["1","01"],["2","02"],["3","03"],["4","04"],["5","05"],["6","06"],["7","07"],["8","08"],["9","09"],["10","10"],["11","11"],["12","12"],["13","13"],["14","14"],["15","15"],["16","16"],["17","17"],["18","18"],["19","19"],["20","20"],["21","21"],["22","22"],["23","23"],["24","24"],["25","25"],["26","26"],["27","27"],["28","28"],["29","29"],["30","30"]]}
Third pop up window error in admin states:
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Warning</b>: mysqli::__construct(): Headers and client library minor version mismatch. Headers:100608 Library:30302 in <b>/home/redacted/shop.indonesianwholesaler.com/system/library/db/mysqli.php</b> on line <b>7</b>{"nl":{"total":"1","amount":"7,930,000 Rp"},"ae":{"total":"1","amount":"1,605,000 Rp"},"gb":{"total":"5","amount":"38,970,000 Rp"},"vn":{"total":"1","amount":"4,295,000 Rp"}}
So I'm currently looking around at the db data & php files, but not sure exactly what's happened...I currently can't change/save any store settings in admin to stop the errors from showing on the live site. I found some currency symbols had become corrupted/changed & I was able to change & save those ok within the admin pages. Some data isn't displaying as well on the admin home page dashboard (map/sales analytics). I'll keep investigating further, but thought I'd ask/see if anyone knows what might have caused this to happen overnight & if there's any known solutions. Thanks in advance for any input.