Author: I downloaded and install the latest version 1.65 however I was getting SQL error every time I tried to add an entry in either the FE or BE. I had to revert to previous version which works fine.
Just FYI
Andre
Just FYI
Andre
Community
Web-Empowered Church User Community
Total Posts: 4 - Pages (1): [1]
aimHi Andre,
So far, no other reports of problems, and this is running fine on other live sites. So I am not sure what is going on. But I would like to find out if it is somehow your server config, mySQL config, or some other variable. Can you capture the mySQL error and post it please? That would be extremely helpful to finding this problem.
If possible, a backend login to your site may be helpful to track it down too.
-Dave
So far, no other reports of problems, and this is running fine on other live sites. So I am not sure what is going on. But I would like to find out if it is somehow your server config, mySQL config, or some other variable. Can you capture the mySQL error and post it please? That would be extremely helpful to finding this problem.
If possible, a backend login to your site may be helpful to track it down too.
-Dave
Dave,
I'm running typo3 4.1 I will reinstall and try to get the error. Strangely it also changed my candle connector to one per row instead of three.
I'll email you back end login once If posted the error
Andre
I'm running typo3 4.1 I will reinstall and try to get the error. Strangely it also changed my candle connector to one per row instead of three.
I'll email you back end login once If posted the error
Andre
Dave,
Here is the error. It occured when I tried to add an entry
Andre
Here is the error. It occured when I tried to add an entry
t3lib_DB::exec_SELECTquery
ERROR 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 'DESC,pid,uid
FROM tx_wecconnector_entries
WHERE
pid=4
lastBuiltQuery SELECT post_date DESC,pid,uid
FROM tx_wecconnector_entries
WHERE
pid=432 AND tx_wecconnector_entries.deleted=0
ORDER BY post_date DESC ASC
LIMIT 1
debug_backtrace sc_alt_doc->processdata // t3lib_tcemain->process_datamap // t3lib_tcemain->getsortnumber // t3lib_db->exec_selectquery // t3lib_db->debug
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /t3lib/class.t3lib_db.php on line 796
caller t3lib_DB::exec_INSERTquery
ERROR 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 'DESC,
pid,
category,
name,
email,
subj
lastBuiltQuery INSERT INTO tx_wecconnector_entries
(
hidden,
parent_uid,
post_date,
user_uid,
post_date DESC,
pid,
category,
name,
email,
subject,
message,
phone,
address,
city,
state,
zipcode,
country,
website_url,
business_name,
contact_name,
email2,
image,
crdate,
cruser_id,
tstamp
) VALUES (
'0',
'0',
'1191886620',
'0',
'256',
'432',
'18',
'test',
'',
'test',
'test',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'1191886645',
'1',
'1191886645'
)
debug_backtrace sc_alt_doc->processdata // t3lib_tcemain->process_datamap // t3lib_tcemain->insertdb // t3lib_db->exec_insertquery // t3lib_db->debug
Warning: Cannot modify header information - headers already sent by (output started at /t3lib/class.t3lib_db.php:1094) in typo3/template.php on line 613
ERROR 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 'DESC,pid,uid
FROM tx_wecconnector_entries
WHERE
pid=4
lastBuiltQuery SELECT post_date DESC,pid,uid
FROM tx_wecconnector_entries
WHERE
pid=432 AND tx_wecconnector_entries.deleted=0
ORDER BY post_date DESC ASC
LIMIT 1
debug_backtrace sc_alt_doc->processdata // t3lib_tcemain->process_datamap // t3lib_tcemain->getsortnumber // t3lib_db->exec_selectquery // t3lib_db->debug
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /t3lib/class.t3lib_db.php on line 796
caller t3lib_DB::exec_INSERTquery
ERROR 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 'DESC,
pid,
category,
name,
email,
subj
lastBuiltQuery INSERT INTO tx_wecconnector_entries
(
hidden,
parent_uid,
post_date,
user_uid,
post_date DESC,
pid,
category,
name,
email,
subject,
message,
phone,
address,
city,
state,
zipcode,
country,
website_url,
business_name,
contact_name,
email2,
image,
crdate,
cruser_id,
tstamp
) VALUES (
'0',
'0',
'1191886620',
'0',
'256',
'432',
'18',
'test',
'',
'test',
'test',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'1191886645',
'1',
'1191886645'
)
debug_backtrace sc_alt_doc->processdata // t3lib_tcemain->process_datamap // t3lib_tcemain->insertdb // t3lib_db->exec_insertquery // t3lib_db->debug
Warning: Cannot modify header information - headers already sent by (output started at /t3lib/class.t3lib_db.php:1094) in typo3/template.php on line 613
Andre
Total Posts: 4 - Pages (1): [1]