RocketTheme - TOPIC: Help with MYSQL error on J1.5 site

Welcome Guest! Login

0 items Join Now

- J!eremy
- Elite Rocketeer
- Posts: 2108
- Thanks: 8
Help with MYSQL error on J1.5 site

Posted 16 years 9 months ago
- Well, This is the only support community that loves anyone, so I didnt know if I could throw this out here for some quick advice.
  
  Here is the Error received:
  mossession::store failed
  DB function failed with error number 1044
  Access denied for user: 'dbo162942373@%' to database 'db162942373' SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '0fbfff2d79150f7fb56a239b001a0707','1216314049','','0','1' )
  
  It is php 4
  The DB is 149.81 MB which is 49.81MB over the limit.
  I was able to browse the site for about 5 minutes and about 10 clicks onto different content, and then recieved it.
  
  I am thinking its logging session information in the DB, and its just way too full...
  
  Thanks again..
  
  again, I have posted this on the mysql forum and the php forum, and havent gotten a response..
  
  James, if you need to delete it, thats cool, just wanted to see if my "Heros" could throw me a bone
- Send moderators PMs ONLY if they request it.
  James' First Blog Post lol
  Top Tips for Support
  Be SPECIFIC when posting.
#202062

J!eremy
Elite Rocketeer
Posts: 2108
Thanks: 8

Re: Help with MYSQL error on J1.5 site

Posted 16 years 9 months ago

Well I have found that between lines 5094 to 332426 (hahahahaa, sorry... ) are pure spam...

such as:

INSERT INTO `jos_sb_messages` VALUES (124732, 683, 683, 2, '18 wheeler american pro trucker screenshots', 0, 'anonymous@forum.here', '18 wheeler american pro trucker screenshots', 1207994502, '220.134.110.231', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124733, 1384, 205, 2, 'mach runner', 0, 'anonymous@forum.here', 'mach runner', 1207994535, '148.78.243.37', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124734, 3368, 205, 2, 'a$%# s^x for white women', 0, 'anonymous@forum.here','a$%# s^x for white women', 1207994535, '200.130.24.36', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124735, 4815, 4815, 2, 'lindsay logan n#%$ photos', 0, 'anonymous@forum.here', 'lindsay logan n#%$ photos', 1207994571, '220.169.248.21', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124736, 1188, 205, 2, 'lindsay lohan warobe malfuction', 0, 'anonymous@forum.here', 'lindsay lohan warobe malfuction', 1207994607, '76.119.41.105', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124737, 1075, 1075, 2, 'payload', 0, 'anonymous@forum.here', 'payload', 1207994612, '148.78.243.37', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124738, 1075, 1075, 2, 'payload', 0, 'anonymous@forum.here', 'payload', 1207994612, '203.20.99.9', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124739, 1188, 205, 2, 'lindsay lohan warobe malfuction', 0, 'anonymous@forum.here', 'lindsay lohan warobe malfuction', 1207994643, '200.79.162.130', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124740, 2739, 205, 2, 'lindsay korman pictures', 0, 'anonymous@forum.here', 'lindsay korman pictures', 1207994670, '200.130.24.36', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124741, 1445, 205, 2, 'lindsay lohan warobe malfuction', 0, 'anonymous@forum.here', 'lindsay lohan warobe malfuction', 1207994729, '134.129.243.72', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124742, 205, 205, 2, 'abbytww', 0, 'anonymous@forum.here', 'good work', 1207994748, '72.55.148.202', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124743, 653, 653, 2, 'lindsay lohan smoking pictures', 0, 'anonymous@forum.here', 'lindsay lohan smoking pictures', 1207994838, '202.28.27.4', 0, 0, 0, 0, 0, 0);
INSERT INTO `jos_sb_messages` VALUES (124744, 1460, 205, 2, 'samsonite', 0, 'anonymous@forum.here', 'samsonite', 1207994913, '202.28.27.4', 0, 0, 0, 0, 0, 0);

Luckily, this is not my site, and I do not am in charge of maintaining it. But... anybody have any ideas on how to scrub the .sql file?

Last Edit: 16 years 9 months ago by .
Send moderators PMs ONLY if they request it.
James' First Blog Post lol
Top Tips for Support
Be SPECIFIC when posting.

#202085

- J!eremy
- Elite Rocketeer
- Posts: 2108
- Thanks: 8
Re: Help with MYSQL error on J1.5 site

Posted 16 years 9 months ago
- Well I fixed it, It basically took me manually removing 300K lines of the sql. But Its done, restored like new. I dont know how to delete this post all together, so I will leave it you my Heros..
- Send moderators PMs ONLY if they request it.
  James' First Blog Post lol
  Top Tips for Support
  Be SPECIFIC when posting.
#202157

Time to create page: 0.073 seconds