 An Installation Problem - Can Someone Help?, Installing Alstrasoft autoresponder pro |
|
|
|
|
  |
 Oct 15 2006, 01:02 AM
Post
#1
|
|
|
Premium Member  Group: Members Posts: 250 Joined: 6-July 06 From: The net (or at least that's what my family says) Member No.: 14,330  |
I'm not sure if I'm in the right sub-forum or not ... but if this should be somewhere else please feel free to relocate!
I have uploaded this PHP app to my server with plans to install it (It's a program like aweber.com) I made the database and started following the installation instructions. The instructions say to run the SQL file (autoresponder.sql). I haven't done this before in phpmyadmin as most php apps I have installed also have an installation script. Needless to say, I got an error: There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 5 MySQL said: Documentation #1064 - 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 'http://blahblahblah(pathname) The program requirements are that I have mysql v 3.23 (or higher) which I have, and php v 4.2.3 (or higher), mine is 4.3.1 Does this make sense to anyone? My knowledge in this area is quite limited so any assistance is greatly appreciated. Thanks, Gin |
 |
 
|
|
Oct 16 2006, 01:26 AM
Post
#2
|
|
|
Super Member  Group: [HOSTED] Posts: 801 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 myCENTs:87.04 |
Well this error happens when you have a parse error in your sql statement like an extra space, when you use a reserved word, when you use quotes.
Which MySql version you have??? Can you PM me the source file to take a look at??? Best regards, |
|
|
|
|
Oct 16 2006, 10:31 AM
Post
#3
|
|
|
Premium Member Group: Members Posts: 250 Joined: 6-July 06 From: The net (or at least that's what my family says) Member No.: 14,330 |
QUOTE(TavoxPeru @ Oct 15 2006, 09:26 PM)  Well this error happens when you have a parse error in your sql statement like an extra space, when you use a reserved word, when you use quotes. Which MySql version you have??? Can you PM me the source file to take a look at??? Best regards, MYSQL is version 3.23. |
|
|
|
|
Oct 16 2006, 02:28 PM
Post
#4
|
|
|
Premium Member Group: Members Posts: 250 Joined: 6-July 06 From: The net (or at least that's what my family says) Member No.: 14,330 |
I found the problem!
|
|
|
|
|
Oct 18 2006, 02:02 AM
Post
#5
|
|
|
Super Member Group: [HOSTED] Posts: 801 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 myCENTs:87.04 |
QUOTE(ginginca @ Oct 16 2006, 09:28 AM) I found the problem! Can you please tell us what is the problem and how you solution it? BTW, i receive your PM bUt i think the file was too long because it dont shows completely, can you please send it again or put an hyperlink to the source to download it complete. Best regards, |
|
|
|
|
Oct 18 2006, 11:52 AM
Post
#6
|
|
|
Premium Member Group: Members Posts: 250 Joined: 6-July 06 From: The net (or at least that's what my family says) Member No.: 14,330 |
QUOTE(TavoxPeru @ Oct 17 2006, 10:02 PM) Can you please tell us what is the problem and how you solution it? BTW, i receive your PM bUt i think the file was too long because it dont shows completely, can you please send it again or put an hyperlink to the source to download it complete. Best regards, I hadn't had to run a sql file before. So I didn't realize I was doing it wrong. The problem was in my method. In the box for the sql file in PHPMYADMIN I was entering the url instead of copying and pasting the contents of the file. Once I got that figured out it worked just fine. :)All part of the learning curve! |
|
|
|
|
Oct 18 2006, 01:12 PM
Post
#7
|
|
|
Guilty Until Proven Innocent Group: Members Posts: 372 Joined: 13-April 05 Member No.: 3,937 |
QUOTE(ginginca @ Oct 18 2006, 07:52 PM) :)All part of the learning curve! i made errors in my early days of database programming.. almost same as yours.. part of learning.. cheers.. |
|
|
|
|
Oct 18 2006, 03:27 PM
Post
#8
|
|
|
Way Out Of Control - You need a life :)  Group: [MODERATOR] Posts: 2,238 Joined: 16-August 05 Member No.: 7,896 myCENTs:34.00 |
QUOTE(vhortex @ Oct 18 2006, 03:12 PM) i made errors in my early days of database programming.. almost same as yours.. part of learning.. cheers.. I'm still makin errors in my current days of database administrating. After ten years experience. Is there a hope of improvement ? Or isn't making errors part of human behaviour ? Personnally, I think that a normal person makes 5 % errors : If you type 100 instructions, there are five lines with errors. The difficult part of the game is finding where the errors are. |
|
|
|
|
Oct 18 2006, 06:04 PM
Post
#9
|
|
|
Premium Member Group: Members Posts: 250 Joined: 6-July 06 From: The net (or at least that's what my family says) Member No.: 14,330 |
QUOTE(yordan @ Oct 18 2006, 11:27 AM) I'm still makin errors in my current days of database administrating. After ten years experience. Is there a hope of improvement ? Or isn't making errors part of human behaviour ? Personnally, I think that a normal person makes 5 % errors : If you type 100 instructions, there are five lines with errors. The difficult part of the game is finding where the errors are. I've only been doing php for about a year. So I still have so much to learn. But I started a course a few weeks ago at college to learn is properly. |
|
|
|
|
Oct 19 2006, 12:36 AM
Post
#10
|
|
|
Super Member Group: [HOSTED] Posts: 801 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 myCENTs:87.04 |
QUOTE(ginginca @ Oct 18 2006, 06:52 AM) I hadn't had to run a sql file before. So I didn't realize I was doing it wrong. The problem was in my method. In the box for the sql file in PHPMYADMIN I was entering the url instead of copying and pasting the contents of the file. Once I got that figured out it worked just fine. :)All part of the learning curve! Dont worry gin, as you say is all part of the learning curve and i'm sure that everybody still making errors including myself, for example, yesterday i spend 1 hour to debug a simple error that i made in an sql select -i forgot to put a single quoute- and my php script dont show anything. I think that we still learn everyday. Best regards, |
|
|
|
|
Similar Topics
| Topics | Topics | |
|---|---|---|
|
|
|
|
Lo-Fi Version | Time is now: 1st December 2008 - 07:42 PM |