Hi ALL I have taken backup of http://mydomain.com/?q=admin/database through drupal 4.6.3 by selecting all tables and it asked me to save as backup.sql. Now when i run [root@e root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal < /home/kaushal/drupal/backup.sql Enter password: ERROR 1064 at line 55817: You have an error in your SQL syntax near '<br /> <b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>' at line 1 [root@e root]# I get the above error Any clue Please let me know if you need more info on this issue Thanks and Regards Kaushal
Kaushal Shriyan wrote:
Now when i run
[root@e root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal < /home/kaushal/drupal/backup.sql Enter password: ERROR 1064 at line 55817: You have an error in your SQL syntax near '<br /> <b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>' at line 1 [root@e root]#
I get the above error
Any clue
PHP by default terminates any script that exceeds 30 seconds of run time. This is to prevent a script from disabling the server by entering an endless loop condition. My diagnosis is that you are using a PHP database administration application (probably phpMyAdmin) to save the database, and the tool needs more than 30 seconds of runtime to perform the operation. Your best bet is probably to perform the backup using the mysqldump command-line tool. Information on this tool is available in the MySQL documentation. Here's the link to the entry in the 5.1 manual; that page contains links to the manual entry for other versions as well. http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html I hope this helps. -- Fergus Gibson ferg@fgibson.ca PGP Public Key: http://www.fgibson.ca/index.php?q=keys
Hi, There's something just not "right" about this error...
[root@e root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal < /home/kaushal/drupal/backup.sql Enter password: ERROR 1064 at line 55817: You have an error in your SQL syntax near '<br />
The above suggests you are using the MySQL command line utility...
<b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>' at line 1
but then this suggests a running php script (or something with a run timeout parameter)? Afaik, the mysql command line utility is not subject to any timeout parameters. What's actually in the file "backup.sql"? SQL code or PHP code? By the looks of things you are trying to restore a backup but it bombs out at line 55817, that right? If so, look in the backup.sql file, specifically line 55817, and you will probably see the error is "bad/mis-placed quote(s)". May be the backup was taken with something incompatible with the MySQL command line util (odd but possible). regards, --AjK
On Fri, 04 Aug 2006 11:03:18 +0200, AjK <drupal@f2s.com> wrote:
There's something just not "right" about this error... but then this suggests a running php script (or something with a run timeout parameter)? Afaik, the mysql command line utility is not subject to any timeout parameters.
I seem to remember I have had timeout errors on a slow linux box with MySQL 4.0 Cannot remember if it was within MySql utility or using MySQL as a command line import (Timeout errors also frequently happen in PPHMyAdmin when restoring large files)
at line 55817, that right? If so, look in the backup.sql file,
When I had this problem restoring a Drupal backup, I had to split a very, very large sql file into five smaller files to avoid the timeout issue. HIH -- Casper Labuschagne +27827054416 www.krooninfo.co.za www.boerboel.co.za Visit http://www.ubuntu.com for a highly recommended open source alternative to Windows!
Id like to create custom contact forms for different types of viewers (Customers verses Vendors). However my understanding is that the Site-Wide Contact Form only allows one contact form type (I do realize with different categories but I dont want Customers to see the Vendors Categories, that would just cause confusion) Here is what I have tried: ----Using Create Page:---- When I view Create Content I see: PAGE: If you want to add a static page, like a contact page or an about page, use a page. But it is not evident how to use PAGE to create a contact page ----Searched web and Drupal Projects---- A bit of searching suggested that webform might be the solution, but looking at the information on webform it says: webform is not a front end for let users create custom nodes. What does this mean? Any comments or suggestions Best Cozzi
Hi Cozzi, On 8/4/06, Cozzi <cozzi@blinkitshere.com> wrote:
I'd like to create custom contact forms for different types of viewers (Customers verses Vendors). However my understanding is that the Site-Wide Contact Form only allows one contact form type (I do realize with different categories but I don't want Customers to see the Vendors Categories, that would just cause confusion)
Here is what I have tried:
----Using Create Page:---- When I view Create Content I see: PAGE: If you want to add a static page, like a contact page or an about page, use a page.
But it is not evident how to use PAGE to create a "contact page"
Pages are mostly just for static content. You could create a "page" to say "call us at..." but they aren't typically used to create dynamic form kinds of things.
----Searched web and Drupal Projects---- A bit of searching suggested that webform might be the solution, but looking at the information on webform it says: "webform is not a front end for let users create custom nodes". What does this mean?
Any comments or suggestions
My suggestion is to use the feedback module. It is an alternative to the core "contact" module that has several features that are slightly different which may make it work for your situation. Another, more complex but still reasonable, solution would be to use CCK to create a custom content type for your contact forms. Then use one of the modules that can email you all new nodes (like the actions module or the subscriptions module). Hope that helps, Greg -- Greg Knaddison | Growing Venture Solutions Denver, CO | http://growingventuresolutions.com Technology Solutions for Communities, Individuals, and Small Businesses
I don't recall the name, but I believe there's a contrib module for 4.7 that splits up the contact form for you into one form per category. I played with it a while back, but don't recall the name. Or you could just use webforms instead of contact.module. On Friday 04 August 2006 10:04, Cozzi wrote:
Id like to create custom contact forms for different types of viewers (Customers verses Vendors). However my understanding is that the Site-Wide Contact Form only allows one contact form type (I do realize with different categories but I dont want Customers to see the Vendors Categories, that would just cause confusion)
Here is what I have tried:
----Using Create Page:---- When I view Create Content I see: PAGE: If you want to add a static page, like a contact page or an about page, use a page.
But it is not evident how to use PAGE to create a contact page
----Searched web and Drupal Projects---- A bit of searching suggested that webform might be the solution, but looking at the information on webform it says: webform is not a front end for let users create custom nodes. What does this mean?
Any comments or suggestions
Best Cozzi
-- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012 "If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson
participants (7)
-
AjK -
Casper Labuschagne -
Cozzi -
Fergus Gibson -
Greg Knaddison - GVS -
Kaushal Shriyan -
Larry Garfield