Weird sql error

Support and feedback for UniAdmin

Weird sql error

Postby DiscoWay » Fri Mar 30, 2007 4:01 am

Zanix,

Ok, so im not sure if this is going to reproduce the error or not, but hopefully it does the same for you when you try it out.

Download this addon
http://ui.worldofwar.net/ui.php?id=3742

Now upload it to uniadmin addons section, using the "no" selection box. After it uploads, edit the version box to 7.1.0. Press apply, now try and get UU to list addons. A mysql error will appear inthe debug and the addons tab will be grayed out.

Code: Select all
[2007/03/29 12:47:29] RetrData: val3: value2
[2007/03/29 12:47:29] RetrData: Timeout: -1
[2007/03/29 12:47:29] RetrData: ------------------------------------------------------------------------
[2007/03/29 12:47:29] SQL query error<br /><br />Query: INSERT INTO `uniadmin_stats` ( `ip_addr` , `host_name` , `action` , `time` , `user_agent` ) VALUES
[2007/03/29 12:47:29]       ( 'xxx.xxx.xxx.xxx', 'd107-141.uoregon.edu', 'GETADDONLIST', '1175197577', 'UniUploader 2.0 (UU 2.6.4; English)' );<br />Message: Table 'uniadmin_stats' is read only<br />Code: 1036
[2007/03/29 12:47:29] RetrData: ------------------------------------------------------------------------
[2007/03/29 12:47:29]
[2007/03/29 12:47:29] Beginning the XML document parsing
[2007/03/29 12:47:29] UpdateAddons: The data at the root level is invalid. Line 1, position 1.
[2007/03/29 12:47:29]  Addons Updated.


Now try deleting all your addons from the UA addons list, now you get this error

Code: Select all
SQL query error

Query: SELECT * FROM `uniadmin_addons` ORDER BY name ASC;
Message: Can't open file: 'uniadmin_addons.MYI' (errno: 145)
Code: 1016


My addons section of UA is completely disabled


Any ideas?
Last edited by DiscoWay on Fri Mar 30, 2007 5:53 am, edited 2 times in total.
User avatar
DiscoWay
WR.net Apprentice
WR.net Apprentice
 
Posts: 25
Joined: Mon Feb 12, 2007 11:40 pm

Re: Weird sql error

Postby DiscoWay » Fri Mar 30, 2007 4:29 am

Wow, so what ever just happened to UA seemed to have killed my mysql service on the server. Gonna have to power cycle the vps. I cant even log in via ssh. All started after uploading that zip file. All my websites are down, gahhhhh. Gonna be a long day =\
User avatar
DiscoWay
WR.net Apprentice
WR.net Apprentice
 
Posts: 25
Joined: Mon Feb 12, 2007 11:40 pm

Weird sql error

Postby DiscoWay » Fri Mar 30, 2007 6:51 am

Disregard this whole thread. I figured out that right as i click the submit button for this file to be uploaded to UA something went terribly wrong on my server and caused it to kill several services. I determined it to be ejabberd. to be the culprit. I started to think something was fishy when i saw a user named ejabberd loging into shell. I checked with my friend and he said he never logged in once. So i suspected something fishy and did a cat /etc/passwd , sure enough i found the user with login rights and deleted it.

scary..
User avatar
DiscoWay
WR.net Apprentice
WR.net Apprentice
 
Posts: 25
Joined: Mon Feb 12, 2007 11:40 pm

Weird sql error

Postby zanix » Fri Mar 30, 2007 7:30 am

I'm kinda frightened too....

Glad you figured it out
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to UniAdmin

Who is online

Users browsing this forum: No registered users and 0 guests

cron