By gordonbooker on

I have a page on my site that looks at some extra tables that I added to the Drupal database in order to give a simple sortable list of some data (song titles and performers in this case)

It was working OK on a Drupal 5.7 site , and works in Drupal 6.3 on my local machine.

I have now changed my site to Drupal 6.3.
The songlist page works, but at the top I get the following error message:

* warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /websites/LinuxPackage04/ti/ma/ds/timadshead.co.uk/public_html/includes/common.inc(1537) : eval()'d code on line 17.
* warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /websites/LinuxPackage04/ti/ma/ds/timadshead.co.uk/public_html/includes/common.inc(1537) : eval()'d code on line 17.
* warning: mysql_result(): supplied argument is not a valid MySQL result resource in /websites/LinuxPackage04/ti/ma/ds/timadshead.co.uk/public_html/includes/common.inc(1537) : eval()'d code on line 18.

which is gobbledygook to me.

It is like this whether I have clean urls on or off.
I wanted my new site to be clean - so deleted the old 5.7 site, emptied the database, installed 6.3 and then copied the database from my local machine onto the web server.

If it is not possible to fix this properly, does anyone know how to just switch the error message off - (the page seems to be working fine)

⋅ Categories: Drupal 6.x

Comments

mantyla’s picture

mantyla commented

Your way of updating seems strange. Drupal has a fine built-in update system, and you really should have used that. The way you did it didn't make anything any cleaner, since you copied all the tables from the old database to the new one, including any junk. It might have made something worse, since the update functions assume that the D6-specific tables don't exist when running the updates.

gordonbooker’s picture

gordonbooker commented

Yup - I understand your point - part of the purpose was to practise with installing Drupal and to practise bringing a whole site over from a local machine to a web server. Everything else worked fine this way. I would love to understand what those mysql errors mean.
For troubleshooting, I will try to load the songlist page onto a fresh Drupal 6.3 install.

gordonbooker’s picture

gordonbooker commented

In case anyone's interested - this issue was resolved by removing

$result = mysql_query($countsql) ;
$var_count = mysql_result($result,0);
echo " There are $var_count songs in total";

from my code.

nikesh’s picture

nikesh commented

I have got same problem when i used to put php code in block(say top articles). when i checked the checkbox of php evaluator this warning appears...

* warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/b/e/l/bellamango/html/D/includes/common.inc(1537) : eval()'d code on line 3.
* warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/content/b/e/l/bellamango/html/D/includes/common.inc(1537) : eval()'d code on line 3.
* warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/b/e/l/bellamango/html/D/includes/common.inc(1537) : eval()'d code on line 4.

please let me know how i can remove this error.

i am a new in drupal

plz help

thanx in advance