Koozali.org: home of the SME Server

Error with MySQL

Offline igardiner

  • *
  • 24
  • +0/-0
Error with MySQL
« on: January 15, 2008, 07:14:31 AM »
Hi All

I've just followed the wiki to install phpMyAdmin onto my SME Server 7.3 server. I have it working fine and have started to develop a test website. I am receiving a 500 Internal Server Error when I am trying to insert a record into the database. I can select my records from the database if I add them in via phpMyAdmin so I'm unsure as to what I have missed.

I have created a user with database privileges to my test database with insert, select, update and delete privileges. The error message says information about the error may be in the server error log. Does anybody know which error log file it is in.

Thanks for any help
Totally New to SME

Offline thomasch

  • *
  • 232
  • +0/-0
Re: Error with MySQL
« Reply #1 on: January 15, 2008, 09:20:11 AM »
SME Server puts all logs in this directory : /var/log/
take your time to browse :
- mysql
- http
- messages
one of them likely show the error log you are looking for

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Error with MySQL
« Reply #2 on: January 15, 2008, 03:58:44 PM »
Hi All

I've just followed the wiki to install phpMyAdmin onto my SME Server 7.3 server. I have it working fine and have started to develop a test website. I am receiving a 500 Internal Server Error when I am trying to insert a record into the database. I can select my records from the database if I add them in via phpMyAdmin so I'm unsure as to what I have missed.

I have created a user with database privileges to my test database with insert, select, update and delete privileges. The error message says information about the error may be in the server error log. Does anybody know which error log file it is in.

Thanks for any help

Have a look on the following section of the wiki as well as you are most certainly hitting a PHP error message which is not displayed to the user by default: http://wiki.contribs.org/PHP#Display_Error_Messages
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline igardiner

  • *
  • 24
  • +0/-0
Re: Error with MySQL
« Reply #3 on: January 15, 2008, 11:25:17 PM »
Thanks a lot for the help guys, I've found what the php error was.

Much appreciated
Totally New to SME

Offline thomasch

  • *
  • 232
  • +0/-0
Re: Error with MySQL
« Reply #4 on: January 16, 2008, 03:10:37 AM »
Edit: Sorry.. I reply wrong message
« Last Edit: January 16, 2008, 03:13:38 AM by thomasch »