Bug #19226
closedMySQL-Error in many Actions
0%
Description
I got many errors when I use the following features:
Record Statistic: Action Update!
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/flugplatz-stade.de/subdomains/www.portal/httpdocs/t3lib/class.t3lib_db.php on line 808
caller 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 'FROM tx_rlmpeventdb_sponsors
WHERE
pid NOT IN (0,2,3,4,389,23,5,7,8,9,10,' at line 2
lastBuiltQuery SELECT uid,pid,
FROM tx_rlmpeventdb_sponsors
WHERE
pid NOT IN (0,2,3,4,389,23,5,7,8,9,10,290,11,12,13,328,247,255,342,343,348,349,350,347,346,345,344,314,364,365,366,369,367,368,370,452,253,351,355,463,252,375,353,381,313,312,488,490,482,391,388,331,472,475,476,473,477,478,474,330,435,449,444,448,445,447,446,443,442,441,440,438,437,329,244,251,250,249,248,14,333,263,450,262,416,418,451,495,260,265,264,261,259,497,466,267,462,461,459,458,454,457,456,455,453,336,273,274,272,276,275,15,304,18,415,238,229,230,232,233,277,22,224,223,222,21,289,231,374,284,485,487,486,491,283,282,281,483,280,468,471,470,484,489,279,278,285,24,332,334,335,338,341,340,339,356,385,357,362,361,360,359,358,373,242,363,225,25,60,61,65,209,205,287,134,64,63,62,67,74,396,395,394,393,392,127,433,380,382,378,420,421,424,425,426,428,430,427,429,431,432,377,376,434,397,383,84,129,73,71,70,69,72,239,240,241,126,128,94,402,85,78,89,90,91,92,115,286,77,125,216,217,218,81,111,112,105,107,106,82,104,102,297,103,299,214,96,117,159,212,79,298,76,399,83,296,295,294,293,292,99,80,95,108,109,110,206,208,86,400,398,303,403,75,116,28,26,88,302,135,97,158,130,132,301,213,215,288,211,114,118,406,119,300,384,237,234,235,236,291,390,221,210,228,372)
debug_backtrace SC_mod_tools_dbint_index->main#695 // SC_mod_tools_dbint_index->func_records#253 // t3lib_admin->lostRecords#500 // t3lib_DB->exec_SELECTquery#333 // t3lib_DB->debug#234
Manage Reference Index: Action Update!
Warning: Invalid argument supplied for foreach() in /srv/www/vhosts/flugplatz-stade.de/subdomains/www.portal/httpdocs/t3lib/class.t3lib_refindex.php on line 1019
caller t3lib_DB::exec_SELECTquery
ERROR MySQL server has gone away
lastBuiltQuery SELECT uid
FROM tt_guest
WHERE
1=1
debug_backtrace SC_mod_tools_dbint_index->main#695 // SC_mod_tools_dbint_index->func_refindex#262 // t3lib_refindex->updateIndex#369 // t3lib_DB->exec_SELECTgetRows#1017 // t3lib_DB->debug#315
Additional Systeminformation:
Linux 10.1
Apache 2.2.3
PHP 5.1.2
MySql 5.0.18
(issue imported from #M9187)
Updated by Steinmeyer Mario almost 16 years ago
Another Information of Tests:
after Update from Typo 4.2 to 4.2.1 I proofed the Consistency with the Database Analyzer and I got a Message: Table and field definitions are OK.
Updated by Dmitry Dulepov almost 16 years ago
Mario, these errors are either from extension or from your database host. Look:
SELECT uid,pid, FROM tx_rlmpeventdb_sponsors
See comma after pid? This SQL is invalid. Most likely extension has errors.
MySQL server has gone away
Google for it. You will find the answer. This is MySQL configuration and nothing to do with TYPO3.
The bug report can be closed.