Category: Content Management Systems

07/12/2007 R Tyler 0 Comments

Here is the error message generated following the addition of a new forum top level topic. The Item was created correctly.

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 ‘)’ at line 1 query: INSERT INTO xmlsitemap_term (tid, pid, last_changed, priority_override) VALUES (11, 0, 1197056606, ) in /home/circlewe/public_html/blog/includes/database.mysql.inc on line 172.

30/11/2007 R Tyler 0 Comments

The following user warning was generated when updating content using Drupal 5. Any pointers as to what might be happening here would be most welcome? === 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 ‘)’ at line 1 query: INSERT INTO xmlsitemap_term (tid, pid, last_changed, priority_override) VALUES(8,0,1196450449,)in home/ circlewe/public_html/blog/includes/database.mysql.inc on line 172.

23/11/2007 R Tyler 0 Comments

The Drupal (CMS) uses .HTACCESS files to control directory access (unless of course you override/remove them and control your settings with modification to your PHP.INI file). On first install of this site I noticed that uploaded images were not visible in the default installation. The way around this is to use the following piece of .htaccess script in the folder where the images are kept on the server. So upload the following script to the offending folder and the images should become visible. SetHandler Drupal_Security_Do_Not_Remove_See_SA_2006_006 Options None