View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002726 | phpList 3 application | Subscribe Process | public | 15-03-05 03:01 | 15-03-05 13:19 |
Reporter | ekriv | ||||
Priority | normal | Severity | crash | Reproducibility | always |
Status | resolved | Resolution | no change required | ||
Product Version | 2.8.12 | ||||
Target Version | Fixed in Version | ||||
Summary | 0002726: Fatal SQL error | ||||
Description | You have serious problam with saving data here: PHPlist - edit a subscribe page. Text boxes (Header, Footer, etc.) can have such sybbols as ", ', etc. which causes SQL error. As result you are loosing data in table phplist_subscribepage_data. | ||||
Additional Information | PHPlist version: 2.8.12 PHP version: 4.3.7 Webserver: Apache/1.3.27 (Unix) (Red-Hat/Linux) FrontPage/5.0.2.2623 mod_ssl/2.8.12 OpenSSL/0.9.6 PHP/4.3.7 mod_perl/1.24_01 Mysql Info: 4.0.20-standard | ||||
Tags | No tags attached. | ||||
|
please explain your problem what are you trying to do what do you expect to happen what happens instead how can we re-create the problem to test what is happening |
|
1. Select subscribe pages from menu 2. Select edit 3. Push button Save Changes 4. You will get SQL error It is the same problem which described in message 0002526 All field values should be escaped with backticks instead of ". |
|
Sorry, unable to duplicate the problem, even after following your steps to repreduce it and in verison 2.8.12 Try to find out what the Sql error is. I can be anything related to your local setup. |
|
Database error 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 'styles/phplist.css" type="text/css" rel="stylesheet"> Database error 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 'menutableright"> |
|
check you magic quotes settings |
|
Thank you very much. With magic_quotes_gpc=On it works now. |