Help with MYSQL error on J1.5 site
-
-
- J!eremy
- Elite Rocketeer
- Posts: 2108
- Thanks: 8
-
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.
-
-
-
- J!eremy
- Elite Rocketeer
- Posts: 2108
- Thanks: 8
-
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: 15 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.
-
-
-
- J!eremy
- Elite Rocketeer
- Posts: 2108
- Thanks: 8
- 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.
-
Time to create page: 0.053 seconds