database , mysql help needed please - GoFuckYourself.com

jódete · 01-20-2014, 02:54 PM

my site is hosted on amerinoc. through the mysql while attempting to modify the message boards post and thread count to make my board look busier i get this response:

Code:

tbl_replace.php: Missing parameter: goto

my cookies are turned on , third party cookies are on , adblock plus is off .
i used firefox , chrome an IE , still no joy.
i managed to alter 1 forum , not able to alter the other forums.

correspondence between me and amerinoc :

Quote:

AmeriNOC Support

11:23 AM (5 hours ago)

to me
How are you 'altering' the tables? Are you doing this through phpMyAdmin? If so, at what URL?

--
Chris Eastman
AmeriNOC Support

Quote:

AmeriNOC Support

4:25 PM (23 minutes ago)

to me
Shouldn't this be something you change in the admin of the script though?

The phpmyadmin issue I believe is due to a version issue because of the outdated version of PHP we haven't been able to update due to users requiring zend optimizer.

--
Chris Eastman
AmeriNOC Support

Quote:

i always altered details through the database.
even if the version is outdated (as it was last year and you haven't updated it) why isn't it working ???? better yet, why did it work once today and then it stopped working ???? Something isn't right here.

Quote:

AmeriNOC Support

4:33 PM (17 minutes ago)

to me
Well if it worked once today and then didn't work, then it isn't a version issue. Sorry I must have missed that.

I'm looking in to this further.

--
Chris Eastman
AmeriNOC Support

any ideas why this is happening ????

sarettah · 01-20-2014, 03:10 PM

It is a phpmyadmin issue probably, not a mysql issue, although it might be being caused by an unrecognized missing key in an index or something like that.

tbl_replace.php is part of phpmyadmin. So, somewhere in phpmyadmin you are ending up at someplace where goto does not exist but it is included in the form call to tbl_change which usually calls tbl_replace.

Oh, and I know that that really does not help you a bit ;p

When in doubt, run check tables against your various tables. It will tell you if there are any index issues.

Wellness Cash · 01-20-2014, 03:43 PM

Might also be a server update they did for another client, we had issues a few years back with a hosting company updating php related functions for one of their clients on the same shared server and it screwed up a bunch of scripts we were running.

DamianJ · 01-20-2014, 03:54 PM

Quote:

Originally Posted by jódete

any ideas why this is happening ????

Is it because they know you're using a fake nick for the 2938298th time?

Why · 01-20-2014, 04:48 PM

it could also be a damaged file in phpmyadmin, you could try to reinstall it.

as someone said above, it appears to be trying to go to a goto that is not present, its possible the entire script is not there or is damaged in some way.

jódete · 01-20-2014, 05:01 PM

Quote:

Originally Posted by sarettah

It is a phpmyadmin issue probably, not a mysql issue, although it might be being caused by an unrecognized missing key in an index or something like that.

tbl_replace.php is part of phpmyadmin. So, somewhere in phpmyadmin you are ending up at someplace where goto does not exist but it is included in the form call to tbl_change which usually calls tbl_replace.

Oh, and I know that that really does not help you a bit ;p

When in doubt, run check tables against your various tables. It will tell you if there are any index issues.

Quote:

Originally Posted by Wellness Cash

Might also be a server update they did for another client, we had issues a few years back with a hosting company updating php related functions for one of their clients on the same shared server and it screwed up a bunch of scripts we were running.

Quote:

Originally Posted by Why

it could also be a damaged file in phpmyadmin, you could try to reinstall it.

as someone said above, it appears to be trying to go to a goto that is not present, its possible the entire script is not there or is damaged in some way.

what i dont get is it worked today 1 time. when i tried to change thread count numbers on another forum the missing parameter response page popped up. it worked with firefox then minutes later it didnt work with firefox. if anything was missing or damaged why would it work 1 time ????

Why · 01-20-2014, 05:54 PM

Quote:

Originally Posted by jódete

what i dont get is it worked today 1 time. when i tried to change thread count numbers on another forum the missing parameter response page popped up. it worked with firefox then minutes later it didnt work with firefox. if anything was missing or damaged why would it work 1 time ????

although rare, files do randomly corrupt for many strange reasons.

are you sure no one else was dicking with your server at the time? phpmyadmin has a number of security issues, maybe someone was attempting to exploit the serveR? host was making changes to phpmyadmin? etc.

freecartoonporn · 01-21-2014, 12:29 AM

phpmyadmin has nothing to do with mysql its just a 3rd party php admin for managing mysql graphically.

reinstall phpmyadmin and try again.

MrGusMuller · 01-21-2014, 02:06 AM

mysql -u username -p databasename

jódete · 01-23-2014, 05:48 AM

appreciate your responses. this was the problem.

Quote:

AmeriNOC Support

1:55 PM (17 hours ago)

to me
I've done some further testing, I've updated/reinstalled software, the highest I can while stuck with the PHP 5.2, and it's still happening. It's an issue with phpmyadmin unfortunately.

If you'd like, I can arrange for you to be moved to a newer server.

--
Chris Eastman
AmeriNOC Support

the $$$$ i spend with amerinoc, i need the db to work the way it should work. i agreed an requested another server.

01-20-2014, 03:10 PM	#2
sarettah l8r Industry Role: Join Date: Oct 2002 Posts: 13,488	It is a phpmyadmin issue probably, not a mysql issue, although it might be being caused by an unrecognized missing key in an index or something like that. tbl_replace.php is part of phpmyadmin. So, somewhere in phpmyadmin you are ending up at someplace where goto does not exist but it is included in the form call to tbl_change which usually calls tbl_replace. Oh, and I know that that really does not help you a bit ;p When in doubt, run check tables against your various tables. It will tell you if there are any index issues. Last edited by sarettah; 01-20-2014 at 03:15 PM..

01-20-2014, 03:43 PM	#3
Wellness Cash Confirmed User Industry Role: Join Date: Nov 2013 Location: Murica Posts: 343	Might also be a server update they did for another client, we had issues a few years back with a hosting company updating php related functions for one of their clients on the same shared server and it screwed up a bunch of scripts we were running. __________________ Wellness Cash - Launching 2014

01-21-2014, 12:29 AM	#8
freecartoonporn Confirmed User Industry Role: Join Date: Jan 2012 Location: NC Posts: 7,681	phpmyadmin has nothing to do with mysql its just a 3rd party php admin for managing mysql graphically. reinstall phpmyadmin and try again. __________________ SSD Cloud Server, VPS Server, Simple Cloud Hosting \| DigitalOcean

01-21-2014, 02:06 AM	#9
MrGusMuller Confirmed User Industry Role: Join Date: Oct 2010 Location: Portugal Posts: 1,261	mysql -u username -p databasename __________________ StagCMS - Adult CMS - user friendly adult content management system - speed up your websites with no SQL connections ICQ: 632343*113

01-20-2014, 04:48 PM	#5
Why MFBA Industry Role: Join Date: Mar 2003 Location: PNW Posts: 7,230	it could also be a damaged file in phpmyadmin, you could try to reinstall it. as someone said above, it appears to be trying to go to a goto that is not present, its possible the entire script is not there or is damaged in some way.