Installation Error At Step #3 (Error populating data into the database)

[verybest]

I think this software sounds wonderful and am trying to install it on my site; I'm receiving the following error at step #3  "Error populating data into the database".  I have confirmed with my provider that the database information (step #2) is correct.  I'm very new at this and i'm just not sure how to proceed.  Thanks in advance for your help.

[Juan Ramón]

Hi,

I need some more info to know about which problem can be... Maybe you can try to download the last oc-installer version. In the last version we warn which error is happening (not the right user/password, problem creating the structure, problem inserting basic data...). In svn you can find the last version: http://code.google.com/p/osclass/source/checkout

I hope it works fine.

[verybest]

I downloaded the latest OC_Installer and got the following error after retrying the installation,
"Can't create database structure. Check if the tables don't exist".
From the error message above, do you have any recomendations as to what i should do next?
I'm sure I've done something wrong...lol...I'm just not sure what it is
Thanks very much for your help,
(I'm on a shared server if that helps)

[Juan Ramón]

Well.. I've just uploaded to svn another version of the installer with more specific message errors.

But now, I just recommend you to check:

• The database exists?
• Has the username and password privileges to do insert and create?
• Are correct username and password?

If not, try to install with the new version and tell me if the error persists, the new message.

[emre]

You get the error because "basic_data_cities.sql" file is 4700KB and your max_execution_time for php scripts probably set for 60 seconds in your main php.ini file. I honestly think that a 4700kb sql file is ridiculous.. This should be corrected by the developers..

Add below code to the top of your /oc-includes/osclass/db.php file:

Code: [Select]

<?php
set_time_limit(3600);
?>

Please note that if your local PHP is running in safe mode the above will not work for you. If this is the case and you are running Apache server, try to add the following line to your .htaccess file:

Code: [Select]

php_value max_execution_time 200


[Juan Ramón]

Hi emre,

In the next version, we're not including those big files (4700kb) and we are going to install only the countries, regions or cities that the user wants. We'll download this data from geo.osclass.org instead of charging from local, this way we'll be able to do more specifics installs.

[ljhelbo]

Hi,

I just found your program - looks just like what I am searching for 

But I also get the installation problem at step 3. The database seems to be populated correctly. It goes to step 3, but I only get the header, so I cant create the admin user. I also use Wampserver on Windows XP. I tried to extend the execution time in php.ini, but it doesn't help, and as I said, I believe the database is populated correctly.

I was wondering, if the problem may be that Wampserver uses php 5.3 (instead of 5.2.x)? I have seen similar problems in some other scripts (but this is only guessing).

I also noticed that some of the php-files does not have a closing ' ? > '. But i dont know, if this might confuse the installation?

Anyway, am I right that you will release the final version within the next week and this will include a new installation procedure? If this is the case, I don't think we should waste much time on this problem 

In that case I would instead spend my time on making a Danish translation. Just to make sure that i am doing the right thing. I translate the file messages.po using Virtaal and adjust the index.php in the same folder, right?

[Juan Ramón]

I don't think php version is the problem, I'm using PHP Version 5.3.1

As you said, we're going to release OSClass 1.0 during this week. This version includes a new installation procedure and more specific explanations when some error happens during the installation. So, if the error still happening, we could see better which error is :-)

About the translation, I always use poedit but I think that Virtaal also serves. When you have the translation, you can just send me to juanramon@osclass.org However, some texts may change but you have done most of the work for the next translation.