Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By ahmaddani on
I just installed my new drupal site at my new host, servage.
But I get some error.
Last my error is :
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 ') AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT query: SELECT DISTINCT(n.nid), n.title, r.body, n.sticky, n.created FROM term_node t INNER JOIN node n ON t.nid = n.nid INNER JOIN node_revisions r ON r.vid = n.vid WHERE t.tid IN () AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 5 in /mounted-storage/home71c/sub004/sc41371-VJKA/esoft.web.id/includes/database.mysql.inc on line 172.
what is this mean ?
and how to solve it?
Comments
Do it manually or log a ticket with Servage
I take it you are using the Autoinstaller. I have tried it a few times in the past and it's never worked for me.
I think you have 2 options.
1) ftp the drupal tarball upto your servage account
or
2) log a ticket with Servage support, they do respond pretty quickly.
regards,
Barry
Thanks... I'l do both of
Thanks... I'l do both of them...
BTW foe no.1, my i raplace them with "new version"; i mean tarbal version. Or reinstall with no database?
Ahmad Daniyal
http://ahmad.indieoffset.com
Shit... 1. My connection so
Shit...
1. My connection so bad.. and i can't upload well. Servage, not like my webhost before, can't not support upload directly from other site.
2. Servage support, event they assist so fast, ask me to contact the support forum of drupal.
Ahmad Daniyal
http://ahmad.indieoffset.com
I have installed new tarbal
I have installed new tarbal version... but.. nothing change.
Ahmad Daniyal
http://ahmad.indieoffset.com
Servage
Ahmad
1) Download tarball to your computer
2) Login to Servage
3) Go to the File Manager
4) upload the drupal tarball to your root directory (i.e. the default Servage lists when you go to File Manager)
5) uncompress the tarball (you need to do this twice, first for the zip then for the tar)
you should now have a directory containing the drupal, next you need to map a virtual host to that directory.
note that it can take a few hours for that virtual host to take effect. E.g. you have www.indieoffset.com, map a virtual host like drupal.indieoffset.com
6) create a database, make a note of the server, username, password
7) try to navigate to drupal.indieoffset.com, once it comes up follow the install instructions, though you will need advanced options to specify your database server name.
regards,
Barry