11
rpilney
Re: database hangs when site loads
  • 2008/5/21 16:32

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


as for the globals setting this was what the hosting company sent to me today:

Thank you for contacting Online Support. The register_globals setting is off by default for all versions of PHP since 4.2.0. This is not something that has recently changed on our servers.

If needed, you can modify your site's register_globals setting using a php.ini file in the root folder of your hosting account. If you do not already have a php.ini file, you can create one with a text editor and upload it to your site via FTP. Unfortunately, customer support is not able to provide directions, technical support, or troubleshooting assistance for the use of php.ini files. I would recommend that you use your favorite search engine to locate directions or see if the creators of the application you are using can assist you.



12
rpilney
Re: database hangs when site loads
  • 2008/5/20 23:29

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


sent you an email. I appreciate the help.



13
rpilney
Re: database hangs when site loads
  • 2008/5/20 23:11

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


Warning [PHP]: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in file header.php line 93
Warning [PHP]: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in file header.php line 109
Notice [PHP]: Undefined variable: link in file header.php line 129
Notice [PHP]: Undefined variable: link in file header.php line 130
Notice [PHP]: Undefined variable: link in file header.php line 131
Notice [PHP]: Undefined variable: link in file header.php line 132
Notice [PHP]: Undefined variable: link in file header.php line 133
Notice [PHP]: Undefined variable: link in file header.php line 134
Notice [PHP]: Undefined variable: link in file header.php line 135
Notice [PHP]: Undefined variable: link in file header.php line 136
Notice [PHP]: Undefined variable: link in file header.php line 137
Notice [PHP]: Undefined variable: link in file header.php line 138
Notice [PHP]: Undefined variable: player_names in file class/xoopsblock.php(146) : eval()'d code line 1
Notice [PHP]: Undefined variable: player_names in file class/xoopsblock.php(146) : eval()'d code line 1



14
rpilney
Re: database hangs when site loads
  • 2008/5/20 23:00

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


ok slowly but surely getting the modules unchecked.

here is my XOOPS info. supposedly I did not install it in the right folder so I can't upgrade the version. :(


XOOPS Version:
XOOPS 2.0.13.2

XOOPS Template Set:
default

PHP Version:
4.3.11

MySQL Version:
4.0.27-max-log

Server Software:
Apache

User's Browser:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; InfoPath.1)



15
rpilney
Re: database hangs when site loads
  • 2008/5/20 22:58

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


trying to deactivate some of the modules listed and the modules control panel will not change when I uncheck it and click submit. It worked one time so far. It will ask me if I want to deactivate them and then when I hit the submit button it goes right back to the way it was.



16
rpilney
Re: database hangs when site loads
  • 2008/5/20 22:48

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


I ran the debugging and got quite a bit in PHP debug mode.

Warning [PHP]: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in file header.php line 93
Warning [PHP]: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in file header.php line 109
Notice [PHP]: Undefined variable: link in file header.php line 129
Notice [PHP]: Undefined variable: link in file header.php line 130
Notice [PHP]: Undefined variable: link in file header.php line 131
Notice [PHP]: Undefined variable: link in file header.php line 132
Notice [PHP]: Undefined variable: link in file header.php line 133
Notice [PHP]: Undefined variable: link in file header.php line 134
Notice [PHP]: Undefined variable: link in file header.php line 135
Notice [PHP]: Undefined variable: link in file header.php line 136
Notice [PHP]: Undefined variable: link in file header.php line 137
Notice [PHP]: Undefined variable: link in file header.php line 138
Notice [PHP]: Undefined variable: player_names in file class/xoopsblock.php(146) : eval()'d code line 1
Notice [PHP]: Undefined variable: player_names in file class/xoopsblock.php(146) : eval()'d code line 1
Notice [PHP]: Use of undefined constant _MI_FUNGAMES_NAME - assumed '_MI_FUNGAMES_NAME' in file modules/fungames/xoops_version.php line 28
Notice [PHP]: Use of undefined constant _MI_FUNGAMES_DESC - assumed '_MI_FUNGAMES_DESC' in file modules/fungames/xoops_version.php line 30
Notice [PHP]: Use of undefined constant _MI_FUNPICTURES_NAME - assumed '_MI_FUNPICTURES_NAME' in file modules/funpictures/xoops_version.php line 28
Notice [PHP]: Use of undefined constant _MI_FUNPICTURES_DESC - assumed '_MI_FUNPICTURES_DESC' in file modules/funpictures/xoops_version.php line 30
Notice [PHP]: Undefined variable: rowRecordset2 in file modules/donations/blocks/Donat_o_Meter.php line 121
Notice [PHP]: Undefined variable: numrows in file modules/xoopspartners/blocks/partners.php line 86



17
rpilney
Re: database hangs when site loads
  • 2008/5/20 22:34

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


thanks for the reply. I have not tried but will now turning off the modules. The reply from my hosting company:

Thank you for contacting Hosting Support.

We have checked the load on your web server and the processes on the MySQL servers hosting your site. We have found nothing to be outside of our normal operating limits. We would recommend checking with the publisher of your forum application for any patches or tweaks which my aid your site's performance.

Please let us know if you have any other questions.

Thank you,
Moe F.
Hosting Support
Hosting Operations



My DB size is 10.3 megs as of last night.



18
rpilney
Re: database hangs when site loads
  • 2008/5/20 4:15

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


I am still having this issue. Site hangs or will not load at all. Hosting company says there is nothing wrong on their end (of course). I have optimized the tables using the optimize module as well as one at a time through their control panel. All say optimized. I don't know what else to make of this.

HELP! :( please



19
rpilney
Re: Purging notifications and PMs from the database: How
  • 2007/7/11 15:25

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


this is how it should look if you use XOOPS care and it does work :) You do have to edit the user, pass, host and DB but that information is found in your mainfile.php file

Quote:


define("user", "dbuser");
define("pass", "dbpass");
define("host", "localhost");
define("db", "dbname");
$cxn = mysql_connect(host ,user, pass);
mysql_select_db(db);
$delete_time = time(30) - ( 30 * 24 * 60 * 60 ); // 30 days/month * 24 hrs/day
// * 60 minutes/hour * 60 seconds/min.

$sql = "DELETE from `xoops_priv_msgs` WHERE `read_msg` = '0' AND `msg_time` < '$delete_time'";
//This script would delete everything older than 30 days that has been not read.

$result = mysql_query($sql, $cxn);










20
rpilney
Re: Purging notifications and PMs from the database: How
  • 2007/7/11 12:50

  • rpilney

  • Just popping in

  • Posts: 76

  • Since: 2006/1/25


cool. I was thinking the same last night. So I pasted in the code just as it is here and saved settings then clicked the do it now link but nothing changed on the PM data size so I know I did something wrong. Do I have to put in my database name, user name etc where it has that listed or just copy and paste as is? Thanks!

just hit edit to add what I saw below lol

For the following, I assume we add our own information?
define("user", "dbuser");
define("pass", "dbpass");
define("host", "localhost");
define("db", "dbname");

FYI I tried adding in the information above, saved settings and then ran it. Did not change. So I wonder where / how I set the time setting i.e. 30 days etc?

I put in 30 in the $delete_time = time() area i.e. time(30) but that did not do it either.

Ideas?

My hosting company does not have CRON jobs for shared servers. only thing I could find is flush the table for PM.

I am assuming that deletes them all which is not what I want. I just want to clean out all the unread ones. I have a few I want to save myself.

Should the "?" be there in front of php? ie <?php




TopTop
« 1 (2) 3 4 5 ... 7 »



Login

Who's Online

106 user(s) are online (71 user(s) are browsing Support Forums)


Members: 0


Guests: 106


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits