UPLOAD Problem : Could not retrieve authorization data, can not proceed.

[evdh]

Could not retrieve authorization data, can not proceed.
Perhaps 'ee_admin' table is missing (wrong EE database version)? Is database online? Is it EE database?

This is what I do :
- Login --> no problem
- Creating an Exhibition --> no problem
- Uploading photo by FTP --> no problem
- Adding these photos to the database in the exhibition (the first 20) --> no problem
- An perhaps uploading the next 20 --> no problem

And then I get that error. While I'm adding photos to the database I get that error. But when I wait some time (30min - 60min) I can start adding photos again. No actions taken. Just wait and all is back to normal...

[Pekka]

See http://photography-on-the.net/forum/showpost.php?p=11188251&postcount=13

[evdh]

I get this error when I want to access the database via phpMyAdmin :

Safari can’t open the page “http://ops.powweb.com/controlpanel/MySQL/login.bml?loginname=photoevdhbe;dbname=evdhbe_ee2” because the server unexpectedly dropped the connection. This sometimes occurs when the server is busy. Wait for a few minutes, and then try again.

[evdh]

This is the error I get in myPHPadmin :

Server: custsql-pow02
Error
SQL query:

SET NAMES utf8;

MySQL said:

#1226 - User 'xxx' has exceeded the 'max_questions' resource (current value: 75000)

This come back from support :

Our records show that that the MySQL queries are exceeding our limits. This is the reason you are receiving error message as 'exceeded the 'max_questions' resource' while accessing phpMyAdmin tool. On our server the maximum number of database queries per user is 75,000/hr.

As a temporary fix, you can delete and recreate your user however this error will still come back if you do not condense the amount of queries your script uses by optimizing your SQL
usage. Below is a link that should help, show you how to optimize your MySQL usage:
http://www.sitepoint.com/article/opt...ql-application . Currently, I was able to access the phpMyAdmin tool for the database user 'xxx'.

Pekka, can you please take a look at this one because 75000 SQL queries is a lot just for uploading 20 photos.
If you need more info from my side, please let me know...

[Pekka]

75000 queries per hour is really low limit. When I was coding EE I did not really think about query limits, frankly. EE does lots of small select queries here and there, and what I was more interested in was combined speed of those queries and especially creating fully relational 100% realtime and complete photo database. I have also always aimed EE to be a personal gallery on personal server. After EE was released VSP and similar part-dedicated hosting solutions got popular and in those setups limits were imposed because the SQL server is shared with even thousands of VPS's.

I know many ways to reduce number of queries a lot, but I really do not have time to do it for EE 2. EE 2 is old code and nowadays I would do many things differently - what next incarnation of POTN will show what I mean in the future. So changing EE 2 to "low query version" would mean some major changes in all parts of it, and it is not worth it in my opinion.

Anyways, EE 2 does not do 75000 queries on uploading 20 photos. But, if you have a live gallery site with even small amount of traffic then EE will surely consume those 75000 in quite a short time, because even simplest app will do that 20 queries a second your host is limited to, per page load, per client. Query limit on a production server will halt your pages now and then and it will cause database corruption, too.

As comparison, POTN does average of 1 million queries per hour, on peak time it's triple that. This is 95% vbulletin-based.

A solution is to change server to one without query limits.

[evdh]

Thanks for the feedback...