By Boletus on

I desperately need assistance. I've been working on a Drupal site for 3 months. Tomorrow we go live. And when I open the page, just before going to bed, the first page is full of this:

Please, please, any hints, anything, what can be done? :(


 * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 37 in /home/public_html/includes/database.mysql.inc on line 438.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 37 in /home/public_html/includes/database.mysql.inc on line 438.
    * user warning: Query was empty query: in /home/public_html/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 10' at line 1 query: LIMIT 0, 10 in /home/public_html/includes/database.mysql.inc on line 172.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 58 in /home/public_html/includes/database.mysql.inc on line 438.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 58 in /home/public_html/includes/database.mysql.inc on line 438.
    * user warning: Query was empty query: in /home/public_html/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 100' at line 1 query: LIMIT 0, 100 in /home/public_html/includes/database.mysql.inc on line 172.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 58 in /home/public_html/includes/database.mysql.inc on line 438.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 37 in /home/public_html/includes/database.mysql.inc on line 438.
    * user warning: Query was empty query: in /home/public_html/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 100' at line 1 query: LIMIT 0, 100 in /home/public_html/includes/database.mysql.inc on line 172.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 58 in /home/public_html/includes/database.mysql.inc on line 438.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 58 in /home/public_html/includes/database.mysql.inc on line 438.
    * user warning: Query was empty query: in /home/public_html/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 100' at line 1 query: LIMIT 0, 100 in /home/public_html/includes/database.mysql.inc on line 172.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 37 in /home/public_html/includes/database.mysql.inc on line 438.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 37 in /home/public_html/includes/database.mysql.inc on line 438.
    * user warning: Query was empty query: in /home/public_html/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 100' at line 1 query: LIMIT 0, 100 in /home/public_html/includes/database.mysql.inc on line 172.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 58 in /home/public_html/includes/database.mysql.inc on line 438.
    * warning: preg_replace() [function.preg-replace]: Compilation failed: lookbehind assertion is not fixed length at offset 58 in /home/public_html/includes/database.mysql.inc on line 438.
    * user warning: Query was empty query: in /home/public_html/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 100' at line 1 query: LIMIT 0, 100 in /home/public_html/includes/database.mysql.inc on line 172.
⋅ Categories: Drupal 5.x

Comments

JohnForsythe’s picture

JohnForsythe commented

Did you install any new modules recently, or change anything on the server side?

--
John Forsythe
Need reliable Drupal hosting?

Boletus’s picture

Boletus commented

I do not think something is changed on the server, I am hosted at a web hotel. It's been working fine until now.

I installed the update_status module yesterday. Earlier today the links to some inline images stopped working.

I am using the Path Filter module, enabling me to use a <img scr="internal:files/file.jpg" /> syntax.

What can I do? Look in the database?

Boletus’s picture

Boletus commented

It seems the error showed up in the log when the Sitemap module was called by google.

Can someone fluent in MySQL dechiper some information from this log entry?

Type	php
Date	Wednesday, March 7, 2007 - 22:51
User	Anonym
Location	http://www.sitename.se/gsitemap
Referrer	
Message	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;DISTINCT(n.nid)), n.type, n.status, n.promote, s.comment_count, n.changed, g.pre&#039; at line 1 query: SELECT DISTINCT( DISTINCT(n.nid)), n.type, n.status, n.promote, s.comment_count, n.changed, g.previously_changed, s.last_comment_timestamp, g.previous_comment, g.priority_override FROM node n LEFT JOIN node_comment_statistics s ON n.nid=s.nid LEFT JOIN gsitemap g ON n.nid=g.nid LEFT JOIN url_alias u ON src=CONCAT(&#039;node/&#039;, n.nid) INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view &gt;= 1 AND ((na.gid = 0 AND na.realm = &#039;all&#039;) OR (na.gid = 1 AND na.realm = &#039;term_access&#039;))) AND ( n.status &gt; 0 AND (g.priority_override &gt;= 0 OR g.priority_override IS NULL) AND n.type NOT IN (&#039;&#039;)) in /home/public_html/includes/database.mysql.inc on line 172.
Severity	error
Hostname	66.249.65.8
JohnForsythe’s picture

JohnForsythe commented

That's a fairly complex error, but it looks like variable "n.nid" is not being properly replaced before the query is sent to MySQL. Why that's happening, I don't know. You may want to run the update script (yoursite.com/update.php) and see if anything is out of date. Also, in my opinion, sitemaps are not that important for Drupal sites. Google generally has no problems crawling through Drupal on its own. You may just want to disable the sitemap module if you can't resolve the problem by other means.

--
John Forsythe
Need reliable Drupal hosting?

Boletus’s picture

Boletus commented

Seems something happened when I enabled the Poll module for the first time. I've searched the logs and found these two entries entries:

php	 
Date	Thursday, March 1, 2007 - 12:54	 
User	admin	 
Location	http://www.site.se/admin/build/modules/list/confirm	 
Referrer	http://www.site.se/admin/build/modules	 
Message	Table &#039;poll&#039; already exists query: CREATE TABLE poll ( nid int unsigned NOT NULL default &#039;0&#039;, runtime int NOT NULL default &#039;0&#039;, active int unsigned NOT NULL default &#039;0&#039;, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/public_html/includes/database.mysql.inc on line 172.	 
Severity	error	 

Type	php
Date	Thursday, March 1, 2007 - 12:54
User	admin
Location	http://www.site.se/admin/build/modules/list/confirm
Referrer	http://www.site.se/admin/build/modules
Message	Table &#039;poll_votes&#039; already exists query: CREATE TABLE poll_votes ( nid int unsigned NOT NULL, uid int unsigned NOT NULL default 0, chorder int NOT NULL default -1, hostname varchar(128) NOT NULL default &#039;&#039;, INDEX (nid), INDEX (uid), INDEX (hostname) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/public_html/includes/database.mysql.inc on line 172.
Severity	error

I am bad at reading this code. What exactly is the error? That table poll_votes already exists or something with characterset?

JohnForsythe’s picture

JohnForsythe commented

Those errors look fairly harmless. It just means the tables already exist, and don't need to be recreated.

--
John Forsythe
Need reliable Drupal hosting?

Boletus’s picture

Boletus commented

Thanks! A helpful soul. :) The last 12 hours has been rough.

There is a bug in the PCRE library that comes to life with PHP 5.2.1. The solution was to downgrade PCRE from 7.0 to an older version.

This seems to have taken care of my problem. Touch wood... Touch wood.

dan.blah’s picture

dan.blah commented

i am going to try boletus's fix but i have found running the upgrade script fixes this as well.
--
blah