Radu Stoica

Registered
Sep 12, 2012
1
0
1
Galati, Romania
cPanel Access Level
Root Administrator
Hey peoples! Yesterday i bought an VPS from a local host. I made some changes in PHP Configuration Editor and now i have some errors on my site from MySql like Warning: mysql_query() [http://www.mysql.com/doc]: Duplicate entry '1' for key 'userid' in /home/foxchat/public_html/wap/core.php on line 2470. Can someone tell me how to reset PHP Configuration or to make default like was first time. Thanks
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Hello,

If you have root SSH access on the machine, please do the following:

Code:
cd /usr/local/lib
mv php.ini php.ini.bak120912
/scripts/phpini
/etc/init.d/httpd restart
This should regenerate the global php.ini file.

Thanks!
 

jrianto

Active Member
Jun 9, 2008
44
0
56
I don't think that has anything to do with your configuration.

That is simply saying that you cannot add another record to your MySql table with the same userid, meaning that your userid table has a unique column attributes.

That is simply an SQL coding that needs to change, nothing to do with any MySql configuration.

Hope that helps.