New Error - ClubWRX Forum - Subaru Impreza WRX and STi Community and Forums

brfatal · 12-06-2009, 09:41 PM

Haven't gotten this one before, now I've gotten it a couple of times.

<br />
<div class="errormessage">
<img class="errormessage" src="http://www.clubwrx.net/openads/www/admin/images/errormessage.gif" align="absmiddle">
<span class='tab-r'>PEAR Error</span>
<br />
<br />MDB2 Error: Array
<br /><pre>_doQuery: [Error message: Could not execute statement]
[Last executed query:
INSERT INTO
oa_data_intermediate_ad
(
day,
hour,
operation_interval,
operation_interval_id,
interval_start,
interval_end,
ad_id,
creative_id,
zone_id,
requests,
impressions,
clicks,
conversions,
total_basket_value,
total_num_items,
updated
)
SELECT
tu.day AS day,
tu.hour AS hour,
tu.operation_interval AS operation_interval,
tu.operation_interval_id AS operation_interval_id,
tu.interval_start AS interval_start,
tu.interval_end AS interval_end,
tu.ad_id AS ad_id,
tu.creative_id AS creative_id,
tu.zone_id AS zone_id,
SUM(tu.requests) AS requests,
SUM(tu.impressions) AS impressions,
SUM(tu.clicks) AS clicks,
SUM(tu.conversions) AS conversions,
IFNULL(SUM(tu.total_basket_value), 0) AS total_basket_value,
IFNULL(SUM(tu.total_num_items), 0) AS total_num_items,
'2009-12-06 21:36:33' AS updated
FROM
tmp_union AS tu
GROUP BY
day,
hour,
operation_interval,
operation_interval_id,
interval_start,
interval_end,
ad_id,
creative_id,
zone_id]
[Native code: 145]
[Native message: Table './clubwrx_ads/oa_data_intermediate_ad' is marked as crashed and should be repaired]
</pre>

</div>
<br />
<br />HTTP/1.1 302 Moved Temporarily
Date: Mon, 07 Dec 2009 05:36:36 GMT
Server: Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
X-Powered-By: PHP/5.2.9
Cache-Control: private
Pragma: private
X-UA-Compatible: IE=7
Location: http://www.clubwrx.net/forums/search...archid=3524526
Content-Length: 0
Keep-Alive: timeout=5, max=97
Connection: Keep-Alive
Content-Type: text/html; charset=ISO-8859-1

WRXie · 12-07-2009, 10:23 AM

I get that too. And for the past two days, it doesn't load the pages for me. It only shows me the coding. I hit reload and it shows the page just fine.

**Rogan** · 12-07-2009, 11:54 AM

I got it, as well, from clicking the "Today's Posts" link..

Code:

MDB2 Error: Array 

_doQuery: [Error message: Could not execute statement]
[Last executed query: 
                INSERT INTO
                    oa_data_intermediate_ad
                    (
                        day,
                        hour,
                        operation_interval,
                        operation_interval_id,
                        interval_start,
                        interval_end,
                        ad_id,
                        creative_id,
                        zone_id,
                        requests,
                        impressions,
                        clicks,
                        conversions,
                        total_basket_value,
                        total_num_items,
                        updated
                    )
                SELECT
                    tu.day AS day,
                    tu.hour AS hour,
                    tu.operation_interval AS operation_interval,
                    tu.operation_interval_id AS operation_interval_id,
                    tu.interval_start AS interval_start,
                    tu.interval_end AS interval_end,
                    tu.ad_id AS ad_id,
                    tu.creative_id AS creative_id,
                    tu.zone_id AS zone_id,
                    SUM(tu.requests) AS requests,
                    SUM(tu.impressions) AS impressions,
                    SUM(tu.clicks) AS clicks,
                    SUM(tu.conversions) AS conversions,
                    IFNULL(SUM(tu.total_basket_value), 0) AS total_basket_value,
                    IFNULL(SUM(tu.total_num_items), 0) AS total_num_items,
                    '2009-12-07 11:53:27' AS updated
                FROM
                    tmp_union AS tu
                GROUP BY
                    day,
                    hour,
                    operation_interval,
                    operation_interval_id,
                    interval_start,
                    interval_end,
                    ad_id,
                    creative_id,
                    zone_id]
[Native code: 145]
[Native message: Table './clubwrx_ads/oa_data_intermediate_ad' is marked as crashed 
and should be repaired]



HTTP/1.1 302 Moved Temporarily Date: Mon, 07 Dec 2009 19:53:27 GMT 
Server: Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 
X-Powered-By: PHP/5.2.9 Cache-Control: private 
Pragma: private X-UA-Compatible: IE=7 
Location: http://www.clubwrx.net/forums/search.php?searchid=3525032 
Content-Length: 0 Keep-Alive: timeout=5, max=94 
Connection: Keep-Alive 
Content-Type: text/html; charset=ISO-8859-1

etshulda · 12-07-2009, 01:45 PM

"I don't see the code anymore...just blonde, brunette, redhead..."

brfatal · 12-07-2009, 01:58 PM

More like dreadheads. OH MY GOSH!

pzr2874 · 12-07-2009, 03:04 PM

Same here on the error messages.

pzr2874 · 12-07-2009, 03:04 PM

Same poo over here....

DUB · 12-07-2009, 03:47 PM

Quote:

Originally Posted by etshulda

"I don't see the code anymore...just blonde, brunette, redhead..."

lulz

WRXie · 12-07-2009, 09:23 PM

I just got it again:

PEAR Error

MDB2 Error: Array

_doQuery: [Error message: Could not execute statement]
[Last executed query:
INSERT INTO
oa_data_intermediate_ad
(
day,
hour,
operation_interval,
operation_interval_id,
interval_start,
interval_end,
ad_id,
creative_id,
zone_id,
requests,
impressions,
clicks,
conversions,
total_basket_value,
total_num_items,
updated
)
SELECT
tu.day AS day,
tu.hour AS hour,
tu.operation_interval AS operation_interval,
tu.operation_interval_id AS operation_interval_id,
tu.interval_start AS interval_start,
tu.interval_end AS interval_end,
tu.ad_id AS ad_id,
tu.creative_id AS creative_id,
tu.zone_id AS zone_id,
SUM(tu.requests) AS requests,
SUM(tu.impressions) AS impressions,
SUM(tu.clicks) AS clicks,
SUM(tu.conversions) AS conversions,
IFNULL(SUM(tu.total_basket_value), 0) AS total_basket_value,
IFNULL(SUM(tu.total_num_items), 0) AS total_num_items,
'2009-12-07 21:21:46' AS updated
FROM
tmp_union AS tu
GROUP BY
day,
hour,
operation_interval,
operation_interval_id,
interval_start,
interval_end,
ad_id,
creative_id,
zone_id]
[Native code: 145]
[Native message: Table './clubwrx_ads/oa_data_intermediate_ad' is marked as crashed and should be repaired]

HTTP/1.1 301 Moved Permanently Date: Tue, 08 Dec 2009 05:21:49 GMT Server: Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 X-Powered-By: PHP/5.2.9 X-Pingback: http://www.clubwrx.net/forums/vbseo-xmlrpc/ Cache-Control: private Pragma: private X-UA-Compatible: IE=7 Location: Snapshot of the day Content-Length: 0 Keep-Alive: timeout=5, max=97 Connection: Keep-Alive Content-Type: text/html; charset=ISO-8859-1

12-06-2009, 09:41 PM	#1 (permalink)
brfatal B...A...R....B....I....E yes i can say it ! Join Date: Dec 2003 Location: Dallas, TX / Centreville, VA Posts: 3,733	New Error Haven't gotten this one before, now I've gotten it a couple of times. <br /> <div class="errormessage"> <img class="errormessage" src="http://www.clubwrx.net/openads/www/admin/images/errormessage.gif" align="absmiddle"> <span class='tab-r'>PEAR Error</span> <br /> <br />MDB2 Error: Array <br /><pre>_doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO oa_data_intermediate_ad ( day, hour, operation_interval, operation_interval_id, interval_start, interval_end, ad_id, creative_id, zone_id, requests, impressions, clicks, conversions, total_basket_value, total_num_items, updated ) SELECT tu.day AS day, tu.hour AS hour, tu.operation_interval AS operation_interval, tu.operation_interval_id AS operation_interval_id, tu.interval_start AS interval_start, tu.interval_end AS interval_end, tu.ad_id AS ad_id, tu.creative_id AS creative_id, tu.zone_id AS zone_id, SUM(tu.requests) AS requests, SUM(tu.impressions) AS impressions, SUM(tu.clicks) AS clicks, SUM(tu.conversions) AS conversions, IFNULL(SUM(tu.total_basket_value), 0) AS total_basket_value, IFNULL(SUM(tu.total_num_items), 0) AS total_num_items, '2009-12-06 21:36:33' AS updated FROM tmp_union AS tu GROUP BY day, hour, operation_interval, operation_interval_id, interval_start, interval_end, ad_id, creative_id, zone_id] [Native code: 145] [Native message: Table './clubwrx_ads/oa_data_intermediate_ad' is marked as crashed and should be repaired] </pre> </div> <br /> <br />HTTP/1.1 302 Moved Temporarily Date: Mon, 07 Dec 2009 05:36:36 GMT Server: Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 X-Powered-By: PHP/5.2.9 Cache-Control: private Pragma: private X-UA-Compatible: IE=7 Location: http://www.clubwrx.net/forums/search...archid=3524526 Content-Length: 0 Keep-Alive: timeout=5, max=97 Connection: Keep-Alive Content-Type: text/html; charset=ISO-8859-1 __________________ awdtuning Mod List

12-07-2009, 10:23 AM	#2 (permalink)
WRXie Flirty User That's Younger Than the Chunks of Corn in Brian's Crap Join Date: Mar 2009 Location: Clarksville, TN Posts: 2,405	I get that too. And for the past two days, it doesn't load the pages for me. It only shows me the coding. I hit reload and it shows the page just fine. __________________ 2002 WRX Yellow Blaze Myspace facebook Bugeye Mafia #216 High Mileage Club

12-07-2009, 01:45 PM	#4 (permalink)
etshulda Registered User Join Date: Oct 2007 Location: NH USA Posts: 595	"I don't see the code anymore...just blonde, brunette, redhead..." __________________ The fast and the "Yeah right!" Blobeye #60 2004 WRX STi Java Black Swirl 2004 WRX san remo wingless sold 99 Impreza 'L' grocery getter sold

12-07-2009, 01:58 PM	#5 (permalink)
brfatal B...A...R....B....I....E yes i can say it ! Join Date: Dec 2003 Location: Dallas, TX / Centreville, VA Posts: 3,733	More like dreadheads. OH MY GOSH! __________________ awdtuning Mod List

12-07-2009, 03:04 PM	#6 (permalink)
pzr2874 Registered User Join Date: Jul 2008 Location: San Antonio Posts: 1,829	Same here on the error messages. __________________ Paul 2007 MS3 Maintenance schedule and poke in the eyes: http://www.clubwrx.net/forums/genera...nce-guide.html

12-07-2009, 03:04 PM	#7 (permalink)
pzr2874 Registered User Join Date: Jul 2008 Location: San Antonio Posts: 1,829	Same poo over here.... __________________ Paul 2007 MS3 Maintenance schedule and poke in the eyes: http://www.clubwrx.net/forums/genera...nce-guide.html

12-07-2009, 09:23 PM	#9 (permalink)
WRXie Flirty User That's Younger Than the Chunks of Corn in Brian's Crap Join Date: Mar 2009 Location: Clarksville, TN Posts: 2,405	I just got it again: PEAR Error MDB2 Error: Array _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO oa_data_intermediate_ad ( day, hour, operation_interval, operation_interval_id, interval_start, interval_end, ad_id, creative_id, zone_id, requests, impressions, clicks, conversions, total_basket_value, total_num_items, updated ) SELECT tu.day AS day, tu.hour AS hour, tu.operation_interval AS operation_interval, tu.operation_interval_id AS operation_interval_id, tu.interval_start AS interval_start, tu.interval_end AS interval_end, tu.ad_id AS ad_id, tu.creative_id AS creative_id, tu.zone_id AS zone_id, SUM(tu.requests) AS requests, SUM(tu.impressions) AS impressions, SUM(tu.clicks) AS clicks, SUM(tu.conversions) AS conversions, IFNULL(SUM(tu.total_basket_value), 0) AS total_basket_value, IFNULL(SUM(tu.total_num_items), 0) AS total_num_items, '2009-12-07 21:21:46' AS updated FROM tmp_union AS tu GROUP BY day, hour, operation_interval, operation_interval_id, interval_start, interval_end, ad_id, creative_id, zone_id] [Native code: 145] [Native message: Table './clubwrx_ads/oa_data_intermediate_ad' is marked as crashed and should be repaired] HTTP/1.1 301 Moved Permanently Date: Tue, 08 Dec 2009 05:21:49 GMT Server: Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 X-Powered-By: PHP/5.2.9 X-Pingback: http://www.clubwrx.net/forums/vbseo-xmlrpc/ Cache-Control: private Pragma: private X-UA-Compatible: IE=7 Location: Snapshot of the day Content-Length: 0 Keep-Alive: timeout=5, max=97 Connection: Keep-Alive Content-Type: text/html; charset=ISO-8859-1 __________________ 2002 WRX Yellow Blaze Myspace facebook Bugeye Mafia #216 High Mileage Club

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PENDING - 500 Internal Server Error - "P" BlazinWRX 6/30/09	psi_guy	Website/Forum Support - Report Errors	10	08-03-2009 04:44 AM
error? wtf you mean error?	indytruckboy	Tuning: Electronic Engine Management	3	01-14-2009 05:05 PM
Kick a$$ error installing AP 2.0	bulletSTI	Tuning: Electronic Engine Management	7	12-29-2006 04:36 PM