Installation error

[bergmanb]

When I click to go to step 3 the next page prints the following line on each line for many hundreds of times. I have to hit stop on the browser to stop the process.

Error: User 'iraqiins_XXXXX' has exceeded the 'max_questions' resource (current value: 50000)


I tell it to install into the same database as my UBB.threads database. 20 tables are created.

If you go to the www.iraqiinsider.com/classifieds/index.php page it prints this:

Database not properly setup - unable to read pp_settings table. Contact administrator.


Any idea why this is all happening?

I am using your 2.2 version of Classifieds.
MySQL version is 4.0.16


Thanks in advance.

[Chuck S]

Your host is limiting the mysql queries and your zipcode data being entered is more than your server allows and they are shutting down mysql

You can remove the zipcode stuff here in install.php to install the program

in install.php find and delete this

// Upload the zipcode data (if present)
$query = @file("zipData.sql");

for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$iquery = str_replace( ";", "", $iquery );
$setup = mysql_query($iquery, $link);
if ( !$setup ) print "<b>Error: ".mysql_error()."</b><br />";
}

You can run the upgrade later and import the zipcode stuff but your still going to trigger that limitation on your server that you host is placing

[bergmanb]

Would I be able to open up the SQL file and do the queries manually through phpMyAdmin? Though looking at the size of that file it seems that may take a while. I figured I could just do a bunch each time until they were all complete.

Otherwise, aside from getting with my provider, how else could I get that stuff installed?

What is the purpose of the zipData.sql file anyways?

[Chuck S]

Yes you can manually do them in phpmyadmin. Everything installs fine on your server its just with your hosts sql query limitation of 50000 query limit a day or whatever it is that zipcode thing will stop your mysql server for at least 10-15 minutes. There are a couple hosts that sell these cheap hosting plans like powweb.com and ipowerweb.com that do this to clients.

If you remove the zipcode you should install fine. The zipcode database provides distance to things.