Project

General

Profile

Actions

Bug #19226

closed

MySQL-Error in many Actions

Added by Steinmeyer Mario almost 16 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
-
Start date:
2008-08-17
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)

Actions

Also available in: Atom PDF