Catalog page error, Admin page cannot login

[leebingjunior]

Hi, I am very new to osCMax, I downloaded v2.0.25 and installed it on my WinXP with Apache 2.2, PHP 5.3.3, and MySql 5.1.

Followed the documentation the installation was smooth, but when I tried to go to the catalog I got the error:

1364 - Field 'country_code' doesn't have a default value

insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', '8n2k074rpt9b4a5p9jnjrm1kf0', '127.0.0.1', 'localhost', '1287979891', '1287979891', '/abc/catalog/index.php', 'http://localhost/abc/catalog/install/install.php?step=4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.7 (KHTML, like Gecko) Chrome/7.0.517.41 Safari/534.7')

[TEP STOP]

I also found I cannot login to the admin page, I tried the username and password I have entered during the installation, but it prompted the "Wrong username and password" message. I checked the table "admin" and found no record inside.

Any help appreciated.

[pgmarshall]

Hi,

The country_code error may be a small dbase setup issue since you are running this locally (although I do the same and have not seen this error message before).

You could try finding the following in catalog/install/osCMax.sql

country_code varchar(2) NOT NULL,

and change it to

country_code varchar(2) NOT NULL default '0',

Not sure if the above is correct nor have I tested it - but it might be worth a go to get you going. If it works - can you post back as this may need to go in the bug tracker.

As for getting into the admin section - try this from the wiki - it should let you create a new user through phpMyAdmin or similar.

Regards,

[leebingjunior]

Hi pgmarshall

Thanks for your reply.

I set the default for country_code, and also country_name, region_name, city, latitude, longitude, now I can see the first page of catalog.

I added a user in table admin, and now I can login to the admin page too.

I suspect that I was having errors which were not reported during the installation, can you tell me the correct number of tables I should have after a successful installation? I am having 95 in total.

Cheers