Contact section not editable

[marino]

I have a problem, which i can't solve. I already read some answers regarding this problem, but nothing helped.
So i want to edit the contact FORM but anything i do nothing helps, it always stays the same.
So the first thing i try is to Load the missing language data but first i have to wait more then 20minutes and it is saying "Processing" after 20minutes it throws me out and i have to login again and the language date is NOT loaded.(see picture for error)
The other thing i was doing is i edited the form in the database, field_descriptions and form_descriptions but even when i changed text here nothing was changed in the storefront.

For the missing language data load error i am adding an screenshot.

Please help.

[Basara]

Hello.

for load missing data error - this is server related issue. Maybe you have too short time limit for execution files or some memory limit. Do you have any errors in AbanteCart error log file?

for other one - after some changes You need to reset AbanteCart cache. Go to Admin-System-Cache

[marino]

Error Log:

Code Select Expand

2013-08-29 18:12:16 - warning:  AbanteCart core v.1.0 file_get_contents(../license.txt) [<a href='function.file-get-contents'>function.file-get-contents</a>]: failed to open stream: No such file or directory in <b>/home1/marino88/public_html/public_html/install/controller/pages/license.php</b> on line <b>39</b>
2013-08-29 18:54:24 - database error:  AbanteCart core v.1.1.6 Error: MySQL server has gone away<br />Error No: 2006<br />SELECT DISTINCT
              e.extension_id,
                      e.type,
                      e.key,
                      e.category,
                      e.priority,
                      e.version,
                      e.license_key,
                      e.date_installed,
                      e.update_date,
                      e.create_date,
              s.store_id,
              st.alias as store_name,
              s.value as status
FROM extensions e
LEFT JOIN settings s ON ( TRIM(s.`group`) = TRIM(e.`key`) AND TRIM(s.`key`) = CONCAT(TRIM(e.`key`),'_status') )
LEFT JOIN stores st ON st.store_id = s.store_id
WHERE e.`type`  IN ('extensions', 'payment', 'shipping', 'template') in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>109</b>
2013-08-29 19:45:49 - warning:  AbanteCart core v.1.1.6 sprintf() [<a href='function.sprintf'>function.sprintf</a>]: Too few arguments in <b>/home1/marino88/public_html/public_html/admin/controller/common/footer.php</b> on line <b>37</b>
2013-08-29 19:48:15 - warning:  AbanteCart core v.1.1.6 sprintf() [<a href='function.sprintf'>function.sprintf</a>]: Too few arguments in <b>/home1/marino88/public_html/public_html/admin/controller/common/footer.php</b> on line <b>37</b>
2013-08-29 19:53:20 - warning:  AbanteCart core v.1.1.6 sprintf() [<a href='function.sprintf'>function.sprintf</a>]: Too few arguments in <b>/home1/marino88/public_html/public_html/admin/controller/common/footer.php</b> on line <b>37</b>
2013-08-29 19:53:23 - warning:  AbanteCart core v.1.1.6 sprintf() [<a href='function.sprintf'>function.sprintf</a>]: Too few arguments in <b>/home1/marino88/public_html/public_html/admin/controller/common/footer.php</b> on line <b>37</b>
2013-08-29 19:58:42 - warning:  AbanteCart core v.1.1.6 Invalid argument supplied for foreach() in <b>/home1/marino88/public_html/public_html/admin/view/default/template/pages/tool/global_search.tpl</b> on line <b>68</b>
2013-08-30 16:35:13 - warning:  AbanteCart core v.1.1.6 sprintf() [<a href='function.sprintf'>function.sprintf</a>]: Too few arguments in <b>/home1/marino88/public_html/public_html/admin/controller/common/footer.php</b> on line <b>37</b>
2013-08-30 16:35:18 - warning:  AbanteCart core v.1.1.6 sprintf() [<a href='function.sprintf'>function.sprintf</a>]: Too few arguments in <b>/home1/marino88/public_html/public_html/admin/controller/common/footer.php</b> on line <b>37</b>


I have no idea what this log means.

I have already reseted my cache several times and i did not help.

[abantecart]

Does this happen all the time or only once in a while?
Looks like your Mysql database is losing connection or dies.

[marino]

Everytime i try to load the missing language data.
The thing is i have my hosting on hostgator and i was testing abantecart on my old hosting and even the load the missing language data worked well there. Now i brought a new hosting plan again at hostgator for the online store and now everytime i try to load the missing language date the thing "crashes".

[abantecart]

Please post your PHP and Mysql versions.

[marino]

PHP: 5.2.17
Mysql: 5.5.30

[abolabo]

why your path have two nested public_html folders? public_html/public_html/

[marino]

It's becuse i have on my first public_html the actual countdown till the store lunches.
I am planing to delete everythig  on the first public_html and move the secund public_html to my first, once the countdown is finished.
In te secund public_html where the abantecart is i am just seting up things. So it's not permenant.

[abolabo]

your error log looks like some server limitations appllied...
hmm..need to investigate. but can you try to ask hosting provider support about mysql crashes first? it's absolutely abnormal behaviour

[marino]

I have send them an email regarding this problem. As soon as i get an answers i will post it here.

[marino]

mysql error log:

Code Select Expand

130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:27 [ERROR] /usr/sbin/mysqld: Table './almujtab_test/jos_session' is marked as crashed and should be repaired
130916 12:17:33 [ERROR] /usr/sbin/mysqld: Table './billy_playangrybird/wp_wbz404_redirects' is marked as crashed and should be repaired
130916 12:17:39 [ERROR] /usr/sbin/mysqld: Table './aelusive_bvlt1/evo_hitlog' is marked as crashed and should be repaired
130916 12:17:39 [ERROR] /usr/sbin/mysqld: Table './aelusive_bvlt1/evo_hitlog' is marked as crashed and should be repaired
130916 12:17:46 [ERROR] /usr/sbin/mysqld: Table './aelusive_bvlt1/evo_hitlog' is marked as crashed and should be repaired
130916 12:17:53 [ERROR] /usr/sbin/mysqld: Table './aelusive_bvlt1/evo_hitlog' is marked as crashed and should be repaired
130916 12:17:54 [ERROR] /usr/sbin/mysqld: Table './aelusive_bvlt1/evo_hitlog' is marked as crashed and should be repaired
130916 12:17:55 [ERROR] /usr/sbin/mysqld: Table './aelusive_bvlt1/evo_hitlog' is marked as crashed and should be repaired
130916 12:18:01 [ERROR] /usr/sbin/mysqld: Table './aelusive_bvlt1/evo_hitlog' is marked as crashed and should be repaired
130916 12:18:02 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:02 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:02 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:02 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:02 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:15 [ERROR] /usr/sbin/mysqld: Table './billy_playangrybird/wp_wbz404_redirects' is marked as crashed and should be repaired
130916 12:18:18 [ERROR] /usr/sbin/mysqld: Table './coolline_sdgnasdg6541qw/qpnahy_online' is marked as crashed and should be repaired
130916 12:18:18 [ERROR] /usr/sbin/mysqld: Table './coolline_sdgnasdg6541qw/qpnahy_online' is marked as crashed and should be repaired
130916 12:18:18 [ERROR] /usr/sbin/mysqld: Table './coolline_sdgnasdg6541qw/qpnahy_online' is marked as crashed and should be repaired
130916 12:18:22 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:18:22 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:18:22 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:18:22 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:18:23 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:18:23 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:18:23 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:18:23 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:18:24 [ERROR] /usr/sbin/mysqld: Table './coolline_sdgnasdg6541qw/qpnahy_online' is marked as crashed and should be repaired
130916 12:18:24 [ERROR] /usr/sbin/mysqld: Table './coolline_sdgnasdg6541qw/qpnahy_online' is marked as crashed and should be repaired
130916 12:18:24 [ERROR] /usr/sbin/mysqld: Table './coolline_sdgnasdg6541qw/qpnahy_online' is marked as crashed and should be repaired
130916 12:18:24 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup_tmp' is marked as crashed and should be repaired
130916 12:18:25 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup' is marked as crashed and should be repaired
130916 12:18:25 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup_tmp' is marked as crashed and should be repaired
130916 12:18:25 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup_tmp' is marked as crashed and should be repaired
130916 12:18:25 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup' is marked as crashed and should be repaired
130916 12:18:25 [ERROR] /usr/sbin/mysqld: Table './billy_playangrybird/wp_wbz404_redirects' is marked as crashed and should be repaired
130916 12:18:39 [ERROR] /usr/sbin/mysqld: Table './jmn2009_jo151/jos_session' is marked as crashed and should be repaired
130916 12:18:39 [ERROR] /usr/sbin/mysqld: Table './jmn2009_jo151/jos_session' is marked as crashed and should be repaired
130916 12:18:40 [ERROR] /usr/sbin/mysqld: Table './jmn2009_jo151/jos_session' is marked as crashed and should be repaired
130916 12:18:40 [ERROR] /usr/sbin/mysqld: Table './jmn2009_jo151/jos_session' is marked as crashed and should be repaired
130916 12:18:40 [ERROR] /usr/sbin/mysqld: Table './jmn2009_jo151/jos_session' is marked as crashed and should be repaired
130916 12:18:41 [ERROR] /usr/sbin/mysqld: Table './billy_playangrybird/wp_wbz404_redirects' is marked as crashed and should be repaired
130916 12:18:42 [ERROR] /usr/sbin/mysqld: Table './billy_playangrybird/wp_wbz404_redirects' is marked as crashed and should be repaired
130916 12:18:42 [ERROR] /usr/sbin/mysqld: Table './billy_playangrybird/wp_wbz404_redirects' is marked as crashed and should be repaired
130916 12:18:49 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:49 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:49 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:49 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:18:49 [ERROR] /usr/sbin/mysqld: Table './aelusive_nuke2/nuke_session' is marked as crashed and should be repaired
130916 12:19:05 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:19:05 [ERROR] /usr/sbin/mysqld: Table './dsmjd_gllr1/sessions' is marked as crashed and should be repaired
130916 12:19:08 [ERROR] /usr/sbin/mysqld: Table './smkalley_wrdp1/wp_options' is marked as crashed and should be repaired
130916 12:19:08 [ERROR] /usr/sbin/mysqld: Table './smkalley_wrdp1/wp_options' is marked as crashed and should be repaired
130916 12:19:08 [ERROR] /usr/sbin/mysqld: Table './smkalley_wrdp1/wp_options' is marked as crashed and should be repaired
130916 12:19:11 [ERROR] /usr/sbin/mysqld: Table './khporter_wdps1/wp_wfHits' is marked as crashed and should be repaired
130916 12:19:16 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup_tmp' is marked as crashed and should be repaired
130916 12:19:16 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup' is marked as crashed and should be repaired
130916 12:19:16 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup_tmp' is marked as crashed and should be repaired
130916 12:19:16 [ERROR] /usr/sbin/mysqld: Table './babi888_wrdp2/wp_wassup_tmp' is marked as crashed and should be repaired
130916 12:19:22 [ERROR] /usr/sbin/mysqld: Table './billy_playangrybird/wp_wbz404_redirects' is marked as crashed and should be repaired
130916 12:19:25 [ERROR] /usr/sbin/mysqld: Table './billy_playangrybird/wp_wbz404_redirects' is marked as crashed and should be repaired
130916 12:19:32 [Note] Found 86765 of 86766 rows when repairing './aelusive_bvlt1/evo_hitlog'
130916 12:19:39 [Note] Found 1 of 2 rows when repairing './babi888_wrdp2/wp_wassup_tmp'
130916 12:19:39 [Note] Found 452 of 451 rows when repairing './billy_playangrybird/wp_wbz404_redirects'
130916 12:19:40 [Note] Found 5 of 8 rows when repairing './citrus_sonali/useronline'
130916 12:19:40 [Note] Found 14 of 9 rows when repairing './coolline_sdgnasdg6541qw/qpnahy_online'
130916 12:19:40 [Note] Found 41854 of 41856 rows when repairing './dsmjd_gllr1/comments'
130916 12:19:46 [Note] Found 4919 of 4920 rows when repairing './dsmjd_gllr1/sessions'
130916 12:19:46 [Note] Found 7 of 8 rows when repairing './hawkmoth_shopping/mori_session'
130916 12:19:55 [Note] Found 22 of 24 rows when repairing './jphayden_joom236/jos_session'
130916 12:20:10 [Note] Found 20236 of 20237 rows when repairing './khporter_wdps1/wp_wfHits'
130916 12:20:13 [Note] Found 912 of 914 rows when repairing './lrobeson_peacechicken/wp_cas_image'
130916 12:20:15 [ERROR] Got error 127 when reading table `./diablo_wrdp7/wp_comments`
130916 12:20:16 [Note] Found 9919 of 9921 rows when repairing './smkalley_wrdp1/wp_options'
130916 12:20:22 [Note] Found 1005 of 1001 rows when repairing './ucgit_breakingfree/watchdog'

[abolabo]

i do not see any abantecart's table there...
looks like mysql crashed.