Problema con Mantenimiento en Admincp

Nanda · 18 Ene 2011

Ok, esto es grande.

Cometí un error, precioné algo que al parecer no debía. Estaba en mi Admincp, me fui a Mantenimiento, Actualizar Contadores, y le dí a una de las opciones (algo de actualizar indices... o algo así, no me acuerdo bien qué decía), pero enmedio del proceso algo falló y mi página esta caida.

Cada vez que intentas entrar te lleva a la dirección:

www.xxx.com/install/install.php

y dice:

Page not found

The page you are looking for might have been removed,
had its name changed, or is temporarily unavailable.

Please try the following: If you typed the page address in the Address bar, make sure that it is spelled correctly.
- Click the Back button in your browser to try another link.
- Use a search engine like Google to look for information on the Internet.
HTTP 404 - File not found

Y ésto fue lo que llegó a mi correo:

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT *
FROM session
WHERE userid = 0
AND host = 'xxxxx'
AND idhash = 'b7a7a78a0f0ab05079e72c6a96628b62'
LIMIT 1;

MySQL Error : User 'xxxxx' has exceeded the 'max_questions' resource (current value: 75000)
Error Number : 1226
Request Date : Tuesday, January 18th 2011 @ 10:38:48 PM
Error Date : Tuesday, January 18th 2011 @ 10:38:48 PM
Script : http://www.xxxxxx.com/showthread.php?584-Concierto-xxxxx9610&highlight=
Referrer :
IP Address : xxxxx
Username :
Classname : vB_Database
MySQL Version :

D': ... qué hago? acaba de pasar pero tengo miedo y no sé que hice.

---------- Actualizado a las 05:02 ---------- Original a las 04:42 ----------

Y me acaba de llegar este otro mail:

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_showthread AS phrasegroup_showthread,
language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
language.phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 2, user.languageid))

WHERE user.userid = xxx;

MySQL Error : User 'xxxx' has exceeded the 'max_questions' resource (current value: 75000)
Error Number : 1226
Request Date : Tuesday, January 18th 2011 @ 10:56:39 PM
Error Date : Tuesday, January 18th 2011 @ 10:56:39 PM
Script : http://www.xxxx.com/showthread.php?558-clase-xxxx
Referrer :
IP Address : xxxx
Username :
Classname : vB_Database
MySQL Version :

Angel Srto · 18 Ene 2011

Nanda, creo que MYSQL ha excedido el máximo de consultas. Deberías ponerte en contacto con tu host y explicarles el error. Reconstruir los idex es un proceso intenso para el servidor, y si te limitan el número de consultas a la db entonces te daría ese error después de intentar algo como reconstruir index.

Probablemente te están limitando a 75000 consultas al mes, o algo parecido.

Nanda · 18 Ene 2011

Gracias Angel

Navegando por internet encontré ésto, que me ayudó (de nuevo mi foro está en linea).

If you get the error on the website, go into your admin panel, then to mysql_admin, delete the user which has generated to many mysql_questions and recreate the user again with the same username/password/rights....

Problema con Mantenimiento en Admincp

Nanda Seguir

Angel Srto

Nanda