View Issue Details

IDProjectCategoryView StatusLast Update
0002726phpList 3 applicationSubscribe Processpublic15-03-05 13:19
Reporterekriv 
PrioritynormalSeveritycrashReproducibilityalways
Status resolvedResolutionno change required 
Product Version2.8.12 
Target VersionFixed in Version 
Summary0002726: Fatal SQL error
DescriptionYou 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 InformationPHPlist 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
TagsNo tags attached.

Relationships

related to 0002036 closedmichiel Magic Quotes problems 

Activities

michiel

15-03-05 03:21

manager   ~0003892

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

ekriv

15-03-05 03:42

reporter   ~0003893

Last edited: 15-03-05 03:50

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

michiel

15-03-05 04:01

manager   ~0003894

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.

ekriv

15-03-05 04:09

reporter   ~0003895

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

michiel

15-03-05 10:47

manager   ~0003901

check you magic quotes settings

ekriv

15-03-05 13:11

reporter   ~0003908

Thank you very much. With magic_quotes_gpc=On it works now.