AbanteCart Community

AbanteCart Development => Customization help => Topic started by: marino on August 29, 2013, 02:41:33 PM

Title: Contact section not editable
Post by: marino on August 29, 2013, 02:41:33 PM
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.
Title: Re: Contact section not editable
Post by: Basara on August 30, 2013, 10:01:08 AM
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
Title: Re: Contact section not editable
Post by: marino on August 30, 2013, 12:45:01 PM
Error Log:
Code: [Select]
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.
Title: Re: Contact section not editable
Post by: abantecart on September 01, 2013, 01:05:09 AM
Does this happen all the time or only once in a while?
Looks like your Mysql database is losing connection or dies.
Title: Re: Contact section not editable
Post by: marino on September 01, 2013, 04:25:13 AM
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".
Title: Re: Contact section not editable
Post by: abantecart on September 01, 2013, 12:35:25 PM
Please post your PHP and Mysql versions.
Title: Re: Contact section not editable
Post by: marino on September 01, 2013, 01:23:44 PM
PHP: 5.2.17
Mysql: 5.5.30
Title: Re: Contact section not editable
Post by: abolabo on September 13, 2013, 04:15:00 AM
why your path have two nested public_html folders? public_html/public_html/
Title: Re: Contact section not editable
Post by: marino on September 13, 2013, 05:17:39 AM
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.
Title: Re: Contact section not editable
Post by: abolabo on September 13, 2013, 02:58:02 PM
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
Title: Re: Contact section not editable
Post by: marino on September 15, 2013, 02:53:54 PM
I have send them an email regarding this problem. As soon as i get an answers i will post it here.
Title: Re: Contact section not editable
Post by: marino on September 16, 2013, 02:29:01 PM
mysql error log:
Code: [Select]
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'
Title: Re: Contact section not editable
Post by: abolabo on September 17, 2013, 04:32:52 AM
i do not see any abantecart's table there...
looks like mysql crashed.