Jump to content

Populate Database Table Error (installation process)


Recommended Posts

I've just installed a fresh prestashop 1.5 on my server, but i'm stuck with this error,

 

I've tried to reinstall it again and again, but always got this error... (file attached)

 

Please help...

post-410991-0-52356600-1350064247_thumb.jpg

Share this post


Link to post
Share on other sites

My site hosted at http://3ix.com

 

Yes, i've just download it. PrestaShop 1.5.1.0

 

Server's info:

 

Apache version : 2.2.23

Php version : 5.2.17

MySQL version : 5.0.95-community

architecture : i686

OS : linux

kernel version : 2.6.18-308.13.1.el5P

Edited by yu7 (see edit history)

Share this post


Link to post
Share on other sites

The previous step, i got the warning on folder and file permissions.

 

These permission settings solved:

 

~/config/ = 0777

~/download/ = 0777

~/img/ = 0776

~/log/ = 0776

~/mails/ = 0776

~/modules/ = 0776

~/upload/ = 0777

~/translations/ = 0776

 

but "cache" folder, i'm stuck. while i set it at 0777 (and subfolders too), the red X still appear. So, when i delete all cache folders content, the red X canged to green, so i can contunue the installation process...

 

Without deleting cache sub-folders, i still got the "populate database Error" ... Help please

post-410991-0-72926300-1350066047_thumb.jpg

Edited by yu7 (see edit history)

Share this post


Link to post
Share on other sites

is the permission recursive or not? if not then better change folder permission with recursive ( in my hosting have option for change folder with recursive )

Share this post


Link to post
Share on other sites

vynx, i guess, the error is not related to file permissions. everything related to file permission are fixed.

 

I guess, there "something" on MySQL server settings are not match with prestashop, or something related to php parameter. I'm still stuck on it... :(

Share this post


Link to post
Share on other sites

Log file content:

 

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Awaiting_cheque_payment" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Payment_accepted" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Preparation_in_progress" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Shipped" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Delivered" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Canceled" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Refund" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Payment_error" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "On_backorder" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Awaiting_bank_wire_payment" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Awaiting_PayPal_payment" for entity "order_state"

*ERROR* 2012/10/12 - 19:34:02: Cannot create image "Payment_remotely_accepted" for entity "order_state"

Share this post


Link to post
Share on other sites

vynx, i guess, the error is not related to file permissions. everything related to file permission are fixed.

 

I guess, there "something" on MySQL server settings are not match with prestashop, or something related to php parameter. I'm still stuck on it... :(

 

i have similiar case before, when i forget to give recursive mode....

Share this post


Link to post
Share on other sites

for user connect to mysql server, its already all priveleges?

 

You mean: database name, username, passwords ? these things are OK. user priviledges All Priviledges are checked...

Edited by yu7 (see edit history)

Share this post


Link to post
Share on other sites

i believe there is another similiar case that already solve, here is another link :

http://www.prestashop.com/forums/topic/194032-solved-cannot-create-image-sql-manager-for-entity-tab/
http://forge.prestashop.com/browse/PSCFV-4809

Share this post


Link to post
Share on other sites

i believe there is another similiar case that already solve, here is another link :

http://www.prestashop.com/forums/topic/194032-solved-cannot-create-image-sql-manager-for-entity-tab/

 

This man's last words: "Another prefix to the DB's, RW access to all files and folders and a reinstall did it for me"

 

I've tried to change any folder and file permissions, it doesn't work...

 

http://forge.prestashop.com/browse/PSCFV-4809

 

I've change file permission of class_index.php file in cache folder to 777. Still got "Populate Database Error"

Edited by yu7 (see edit history)

Share this post


Link to post
Share on other sites

i don't know... may be stuck of Linux server-Limited of server!!!!! i have same issue with cheap hosting & shared host!! u can try other hosting or u can try at localhost first!! ask you hosting provider to help u above directory permission!

Share this post


Link to post
Share on other sites

i don't know... may be stuck of Linux server-Limited of server!!!!! i have same issue with cheap hosting & shared host!! u can try other hosting or u can try at localhost first!! ask you hosting provider to help u above directory permission!

 

Jesen! Thanks, i've tried to install it offline, on localhost with xampp. everything is OK!

BUT, after i upload files to the server, all links in menus, articles, products, all are directed to the offline server / localhost.

AND, admin (i have renamed the folder) login page didn't react even the login form was filled with correct email and password...

 

Any sugestion, or articles about this prob??

Share this post


Link to post
Share on other sites

there is some tips about moving prestashop from one host to another but i never try :

 

http://www.howtomakeawebshop.com/tip-3-moving-prestashop-from-one-host-to-another/

 

my suggestion better settle the problem in the hosting first.

Share this post


Link to post
Share on other sites

there is some tips about moving prestashop from one host to another but i never try :

 

http://www.howtomakeawebshop.com/tip-3-moving-prestashop-from-one-host-to-another/

 

my suggestion better settle the problem in the hosting first.

 

did it like vynx told!! :ph34r:

Share this post


Link to post
Share on other sites
  • 1 year later...

You might want to check your database users privileges.

 

First go into php admin and see that all tables are empty.

if yes then try to manually insert an entry into some table.

 

Then see if the entry is really inserted into the table.

If not, then your database user are missing some privileges.

Share this post


Link to post
Share on other sites
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More