Project

General

Profile

Actions

Bug #19226

closed

MySQL-Error in many Actions

Added by Steinmeyer Mario over 16 years ago. Updated about 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 #1

Updated by Steinmeyer Mario over 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.

Actions #2

Updated by Dmitry Dulepov over 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.

Actions #3

Updated by Dmitry Dulepov over 16 years ago

Not a TYPO3 core problems

Actions #4

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF