Tables will not load

New Member Joined: Aug 17, 2008 Posts: 2

Hi, I'm trying to installed 2.30.02 and am running into a snag right away. I uploaded all the files to my webserver and then went to the domain, I got the appropriate message and then continued along to the INSTALLATION/installSQL.php page.

Now when on that page I don't get the buttons that the screenshot shows, just text for Step 1-3. I click on Load Core Tables and it flashes loaded such and such for a sec then goes back to Not Loaded on the right hand side. Same thing with all the other steps.

I get this error message at the bottom of the screen when I navigate to installSQL.php

Code:

Warning: Unknown: open(/var/php_sessions/sess_5887e3739ac101df48ac72e4c267f839, O_RDWR) failed: No such file or directory (2) in Unknown on line 0





Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/php_sessions) in Unknown on line 0

I went through and clicked on all the table loading steps just for the heck of it and ended up getting this error near the end

Code:

The exact error message that your MySQL server reported is:


MySQL Error # 4 at line 115 in file installSQL.php ==> User '*****' has exceeded the 'max_questions' resource (current value: 75000)

Any help is greatly appreciated.
Thanks.

Posted: Tue Aug 25, 2009 3:09 pm

Sounds like a problem your host needs to solve. I would contact them with those errors.

Posted: Tue Aug 25, 2009 4:04 pm

Alright thanks, I've contacted them and the issue was forwarded to a specialist on the matter. Hopefully it's something that can be changed...from what I can gather it's an SQL query limit issue, I'm not holding my breath though as I was told that limit cannot be changed. Is anyone aware of what a "normal" limit is, or an average at that for most hosts using cPanel.

Posted: Thu Aug 27, 2009 6:03 am

I have heard 50,000 queries per hour and it looks like they have 75,000. RavenWebHosting doesn't have this limit... Wink

To fully install the DB, you'll have to come back in an hour, most likely, and start where you left off and keep doing this until its done. You may still have issues down the road if your site is going to be very active as *nuke, being a CMS, is highly database dependent... There is a thread in these forums somewhere which talks about how to split your calls up across multiple users, which is one way in which you may be able to get around this issue. (Don't tell them that!!!)

I think their session handling setup isn't correct either for your account.

New Member Joined: Nov 10, 2012 Posts: 4

Thanks for the info montego but I'm still curious. Is this something I can contact my host to change? Or can I configure it myself and set the value higher? Not exactly sure where I should look. maybe my .ini?

Posted: Sun Nov 11, 2012 5:01 pm

I'm having this same problem except I also am getting this

Warning: Unknown: open(/var/php_sessions/sess_a50bf89663fcd2fb979b547cfca18369, O_RDWR) failed: No such file or directory (2) in Unknown on line 0 Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/php_sessions) in Unknown on line 0

What does this mean?

Site Admin Joined: Jun 04, 2004 Posts: 6432

Sounds like a permissions issue, not in your CMS configuration, but maybe in the server's configuration. As before, I'd recommend contacting your host.