AbanteCart Community

eCommerce construction => Installation and Configuration => Topic started by: popustda on April 23, 2014, 08:16:43 AM

Title: country problem
Post by: popustda on April 23, 2014, 08:16:43 AM: Hi,
today i opened my admin and i noticed that my country is not showing under the list and it changed to "zimbabwe" and i cant change it. I think this is some kind of a bug.
I am attaching a few pictures so you can see what i mean. Please help me because i was working on my website for a months now and it seems like something is wrong now
The whole site now allows only one country, "zimbabwe"

Thanks
Title: Re: country problem
Post by: popustda on April 23, 2014, 09:24:13 AM: when i deleted "zimbabwe" from the list of countries, now everything is set with next last country on the list which is "Zambia".
Please help me!

thx
Title: Re: country problem
Post by: Basara on April 23, 2014, 10:32:36 AM: Hello.
Did You see Your country in Admin-System-Localization-Countries? If not add it manually at same place there is Insert button in the right corner of the countries grid
Title: Re: country problem
Post by: popustda on April 23, 2014, 10:39:03 AM: yes i see my country and it worked fine until yesterday.
now whatever i do it only shows one country and its always last caountry in the list in "Admin-System-Localization-Countries"
I have many countries enabled but when customer is trying to create a new account , it can only choose "zambia" in the country list.
Title: Re: country problem
Post by: Basara on April 23, 2014, 10:40:55 AM: Quote from: popustda on April 23, 2014, 10:39:03 AM
yes i see my country and it worked fine until yesterday.
now whatever i do it only shows one country and its always last caountry in the list in "Admin-System-Localization-Countries"
I have many countries enabled but when customer is trying to create a new account , it can only choose "zambia" in the country list.

Please check AbanteCart error log and also try to clear AbanteCart cache (Admin-System-Cache)
Title: Re: country problem
Post by: popustda on April 23, 2014, 10:53:54 AM: this means anything to you?

thx
Title: Re: country problem
Post by: popustda on April 23, 2014, 10:56:26 AM: better quality
Title: Re: country problem
Post by: Basara on April 24, 2014, 02:57:46 AM: Hello. Your screenshots are bad readable.
The better way is to copy text and paste it here.
I see a lot of errors:
* one of the about accessing store with unconfigured domain - please check your domain settings at Admin-System-Settings-Details Tab (http://www.abantecart.com/ecommerce-documentation/50-admin-user-manual/system/settings#Details%20Tab) look for Store URL value
* allowed memory size issue usually indicate that your have not enough RAM or disk space at your hosting

Also a lot of other issues please post here in readable way and hope AbanteCart community find solution for all of them
Title: Re: country problem
Post by: popustda on April 24, 2014, 04:16:33 AM: second part :)

Check setting of your store domain URL in System Settings . Loading default store configuration for now. in /home/topducan/public_html/core/lib/config.php on line 169
2014-04-23 13:05:25 - error: AbanteCart core v.1.1.8 Allowed memory size of 134217728 bytes exhausted (tried to allocate 124049409 bytes) in /home/topducan/public_html/admin/controller/pages/tool/backup.php on line 307
2014-04-23 13:05:53 - error: AbanteCart core v.1.1.8 Allowed memory size of 134217728 bytes exhausted (tried to allocate 124049409 bytes) in /home/topducan/public_html/admin/controller/pages/tool/backup.php on line 307
2014-04-23 17:35:34 - App Warning: AbanteCart core v.1.1.8 Warning: Accessing store with unconfigured or unknown domain ( 181.224.131.166/ ).
Check setting of your store domain URL in System Settings . Loading default store configuration for now. in /home/topducan/public_html/core/lib/config.php on line 169
Title: Re: country problem
Post by: Basara on April 24, 2014, 04:18:24 AM: Quote from: popustda on April 24, 2014, 04:16:10 AM
Here is the copy of log file. I hope you guys can help me because i like this cart so much but i am not very good with programming
i cant put everything because of 20,000characters limit :)

Did You check your settings as described above?
Title: Re: country problem
Post by: popustda on April 24, 2014, 04:27:35 AM: i deleted one more country from the list "zambia" and now i can choose country in the system and this works.
Can you check my log file and tell me if something else is wrong with my site so i can fix it.
For me it seems now like everything is ok
Title: Re: country problem
Post by: Basara on April 24, 2014, 04:33:05 AM: Quote from: Basara on April 24, 2014, 02:57:46 AM
Hello. Your screenshots are bad readable.
The better way is to copy text and paste it here.
I see a lot of errors:
* one of the about accessing store with unconfigured domain - please check your domain settings at Admin-System-Settings-Details Tab (http://www.abantecart.com/ecommerce-documentation/50-admin-user-manual/system/settings#Details%20Tab) look for Store URL value
* allowed memory size issue usually indicate that your have not enough RAM or disk space at your hosting

Also a lot of other issues please post here in readable way and hope AbanteCart community find solution for all of them
Title: Re: country problem
Post by: popustda on April 24, 2014, 04:40:51 AM: i am not sure about RAM but disk space is not a problem since i have 20GB.
Regarding unconfigured domain, i think evrything is ok. my domain is topducan.eu and store url i put: http://topducan.eu/

But now i have other problem. i cant access system/settings. its just empty. (please check picture)
Title: Re: country problem
Post by: abantecart on April 24, 2014, 09:54:15 AM: popustda please do not post large logs in the forum. Only last 3-4 lines are relevant.
In case, you need to post large log, post in attached text file
Title: Re: country problem
Post by: popustda on April 24, 2014, 09:57:52 AM: ok sorry.
here is a log of last few lines.(i dont understand why it says here version 1.1.6 when i originaly installed AbanteCart newest version 1.1.8)?

2014-04-24 7:59:47 - database error: AbanteCart core v.1.1.6 Error: MySQL server has gone away Error No: 2006 SELECT dataset_id
 FROM 9u9_datasets
 WHERE dataset_name = 'install_upgrade_history'
 AND dataset_key='admin' LIMIT 1 in /home/topducan/public_html/core/database/mysql.php on line 109
2014-04-24 8:15:54 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagesextensionextensions::language! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
2014-04-24 8:16:03 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagesextensionextensions::language! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
2014-04-24 8:16:07 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagesextensionextensions::language! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
2014-04-24 8:16:11 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagesextensionextensions::language! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
2014-04-24 12:29:16 - warning: AbanteCart core v.1.1.6 mysql_real_escape_string() expects parameter 1 to be string, array given in /home/topducan/public_html/core/database/mysql.php on line 119
2014-04-24 12:29:16 - warning: AbanteCart core v.1.1.6 mysql_real_escape_string() expects parameter 1 to be string, array given in /home/topducan/public_html/core/database/mysql.php on line 119
2014-04-24 12:56:08 - warning: AbanteCart core v.1.1.6 mysql_real_escape_string() expects parameter 1 to be string, array given in /home/topducan/public_html/core/database/mysql.php on line 119
2014-04-24 12:56:28 - warning: AbanteCart core v.1.1.6 mysql_real_escape_string() expects parameter 1 to be string, array given in /home/topducan/public_html/core/database/mysql.php on line 119
2014-04-24 12:57:08 - warning: AbanteCart core v.1.1.6 mysql_real_escape_string() expects parameter 1 to be string, array given in /home/topducan/public_html/core/database/mysql.php on line 119
2014-04-24 13:00:07 - warning: AbanteCart core v.1.1.6 mysql_real_escape_string() expects parameter 1 to be string, array given in /home/topducan/public_html/core/database/mysql.php on line 119
Title: Re: country problem
Post by: abantecart on April 24, 2014, 10:02:57 AM: Based on the log you have all sorts of problems.

1. Mysql connection drops.
2. Are you developing an extension?
3. I do not think these are related to the country problem that you report

Are you sure you are looking at correct place? If log said 1.1.6 it is the version that you use.
Title: Re: country problem
Post by: popustda on April 24, 2014, 10:06:05 AM: look here please. it was version 1.1.8 and a few lines below moved to 1.1.6

2014-04-21 13:20:36 - App Warning: AbanteCart core v.1.1.8 Warning: Accessing store with unconfigured or unknown domain ( 181.224.131.166/ ).
Check setting of your store domain URL in System Settings . Loading default store configuration for now. in /home/topducan/public_html/core/lib/config.php on line 169
2014-04-22 6:14:10 - App Warning: AbanteCart core v.1.1.8 Warning: Accessing store with unconfigured or unknown domain ( 181.224.131.166/ ).
Check setting of your store domain URL in System Settings . Loading default store configuration for now. in /home/topducan/public_html/core/lib/config.php on line 169
2014-04-22 20:41:33 - App Warning: AbanteCart core v.1.1.8 Warning: Accessing store with unconfigured or unknown domain ( 181.224.131.166:81/ ).
Check setting of your store domain URL in System Settings . Loading default store configuration for now. in /home/topducan/public_html/core/lib/config.php on line 169
2014-04-23 13:05:25 - error: AbanteCart core v.1.1.8 Allowed memory size of 134217728 bytes exhausted (tried to allocate 124049409 bytes) in /home/topducan/public_html/admin/controller/pages/tool/backup.php on line 307
2014-04-23 13:05:53 - error: AbanteCart core v.1.1.8 Allowed memory size of 134217728 bytes exhausted (tried to allocate 124049409 bytes) in /home/topducan/public_html/admin/controller/pages/tool/backup.php on line 307
2014-04-23 17:35:34 - App Warning: AbanteCart core v.1.1.8 Warning: Accessing store with unconfigured or unknown domain ( 181.224.131.166/ ).
Check setting of your store domain URL in System Settings . Loading default store configuration for now. in /home/topducan/public_html/core/lib/config.php on line 169
2014-04-24 7:42:39 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagessettingsetting::details! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
2014-04-24 7:42:46 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagessettingsetting::general! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
2014-04-24 7:43:10 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagessettingsetting::details! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
2014-04-24 7:43:46 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagessettingsetting::details! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
2014-04-24 7:58:42 - method not exist: AbanteCart core v.1.1.6 Error: controller method not exist Controllerpagessettingsetting::details! in /home/topducan/public_html/core/engine/dispatcher.php on line 315
Title: Re: country problem
Post by: abantecart on April 24, 2014, 03:07:12 PM: Did you read before, what I said about posting long logs?

I do not see how version can change back on it's own, unless you override files or do some modifications.
Title: Re: country problem
Post by: popustda on April 25, 2014, 10:43:27 AM: i made a mistake by manually downgrading to 1.1.6 version and after that i downloaded 1.18 and i returned it also manualy but now i hve these problem.
Can you please tell me what to do to fix it. I tried auto upgrade to 1.1.8 but it shows me error.
Pleas check log: ( i hope its not to big now)

ALTER TABLE `9u9_global_attributes` ADD COLUMN `regexp_pattern` varchar(255);
in /home/topducan/public_html/core/database/mysql.php on line 114
2014-04-25 13:42:48 - error: AbanteCart core v.1.1.7 Call to undefined method ALayoutManager::clonePageLayout() in /home/topducan/public_html/admin/model/catalog/product.php on line 1064
2014-04-25 13:43:02 - database error: AbanteCart core v.1.1.7 Error: Duplicate key name '9u9_languages_index' Error No: 1061 
CREATE UNIQUE INDEX `9u9_languages_index`
ON `9u9_languages` (`language_id`, `code`);
in /home/topducan/public_html/core/database/mysql.php on line 112
Title: Re: country problem
Post by: abantecart on April 25, 2014, 02:01:26 PM: The easiest solution, is to copy all the files (except config file) over your files.
You can backup the data, install new store and extract back up.
Title: Re: country problem
Post by: popustda on April 25, 2014, 02:20:31 PM: you mean i download upgrade 1.1.8 and extract everything from "code" file to my host and then make backup, then install new cart and restore this backup there?
Title: Re: country problem
Post by: abantecart on April 25, 2014, 04:43:55 PM: NO. You need to download complete distribution and replace all code. BACK UP first
Title: Re: country problem
Post by: popustda on April 25, 2014, 04:47:59 PM: is this normal to have everythng starts ewith 9u9
Title: Re: country problem
Post by: llegrand on April 25, 2014, 05:07:55 PM: that is the database prefix that was appended (added) at some stage in your setup. Consider it just part of your database tables names.
Lee
Title: Re: country problem
Post by: popustda on April 26, 2014, 04:02:38 AM: Can yuo please check a file i attached and let me know since my DB prefix in config.php is "9u9_" do i have to change ac_ to 9u9_ in upgrade.sql to manually upgrade it?

Also my .htaccess file is strange. i think it should have more lines inside, right?
Title: Re: country problem
Post by: Basara on April 28, 2014, 03:10:00 AM: Quote from: popustda on April 26, 2014, 04:02:38 AM
Can yuo please check a file i attached and let me know since my DB prefix in config.php is "9u9_" do i have to change ac_ to 9u9_ in upgrade.sql to manually upgrade it?

Also my .htaccess file is strange. i think it should have more lines inside, right?

Hello.
Yes change prefix to 9u9_
About the htacess see its default content https://github.com/abantecart/abantecart-src/blob/master/public_html/.htaccess.txt
Title: Re: country problem
Post by: popustda on April 28, 2014, 03:39:37 AM: i changed every sc_ to 9u9_ and tried importing in phpmyadmin but i get this error
THX