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.
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
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
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