1. Terry_Karv
  2. RO CSVI
  3. Saturday, 28 April 2018
  4.  Subscribe via email
Hello,

I have the following problem. I was exporting the Joomla menu succefully,
I added some information to the same csv file and tried to import. Here is the following message:

Status error: 200
Status message: OK
{"error":true,"process":false,"url":"administrator\/index.php?option=com_csvi&view=imports","message":"Table '#__extensions' was not locked with LOCK TABLES"}
Fatal error: Uncaught JDatabaseExceptionExecuting: Table '#__users' was not locked with LOCK TABLES in C:\xampp\htdocs\railkar\libraries\joomla\database\driver\mysqli.php:650 Stack trace: #0 C:\xampp\htdocs\railkar\libraries\joomla\database\driver.php(1455): JDatabaseDriverMysqli->execute() #1 C:\xampp\htdocs\railkar\libraries\src\Table\User.php(86): JDatabaseDriver->loadAssoc() #2 C:\xampp\htdocs\railkar\libraries\src\User\User.php(883): Joomla\CMS\Table\User->load('610') #3 C:\xampp\htdocs\railkar\libraries\src\User\User.php(943): Joomla\CMS\User\User->load('610') #4 [internal function]: Joomla\CMS\User\User->__wakeup() #5 C:\xampp\htdocs\railkar\libraries\vendor\joomla\registry\src\Registry.php(85): unserialize('O:8:"stdClass":...') #6 C:\xampp\htdocs\railkar\libraries\src\Session\Session.php(386): Joomla\Registry\Registry->__clone() #7 C:\xampp\htdocs\railkar\libraries\joomla\session\handler\native.php(189): Joomla\CMS\Session\Session->getData() #8 [internal function]: JSessionHandlerNative->save() #9 {main} thrown in C:\xampp\htdocs\railkar\libraries\joomla\database\driver\mysqli.php on line 650
Warning: Unknown: Failed to write session data using user defined save handler. (session.save_path: C:\xampp\tmp) in Unknown on line 0


I'm probably doing something wrong because I'm a beginner, but I can not find it yet!!

Regards
Terry_K

Joomla!, 3.8.7
VirtueMart 3.2.12
CSVI Pro 7.6.1
PHP/7.2.4
Accepted Answer Pending Moderation
Hello Terry_K,
The errors you are seeing is not because of CSVI but that the user you are using to access the database may not be having privilege to lock the tables. In your PhpMyAdmin, click on user accounts tab and check the privileges given to the database user you use in your Joomla website. To know the user, go to your Joomla root directory and check the configuration.php file with line public $user = 'XXX';
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Terry_K,
You can also check the database user from Joomla administrator >> Global configuration page >> Server tab and in Database Username field.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Τhank you for your response.

I did a check on the database user and has all the privilege! Is there anything else I could check?

Regards
Terry_K

Joomla!, 3.8.7
VirtueMart 3.2.12
CSVI Pro 7.6.1
PHP/7.2.4
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Terry_K,
This is not a CSVI error but still to help you with your import, try to run the below queries by going to PhpMyAdmin >> Select your database >> Click on SQL tab >> Paste the queries >> Click Go. See if you are able to import after that.
Don't forget to replace #_ with your table prefix.

 LOCK TABLE `#__extensions` read; 
LOCK TABLE `#__users` read;
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Τhank you very much for your time especially since it is not the error of csvi.

Ι did what you suggested me but the error remains...

mysql returns empty result set...

Ιf you have the time to direct me, I would appreciate it very much

Regards
Terry_K
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Terry_K,
Are you seeing this error only with CSVI import? How about accessing other pages? Also, I see that you are running the Joomla instance on your local server. How about you create another Joomla instance, install CSVI and run the import? Just to confirm if it is not something to do with Joomla installation.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Tharuna. Τhank you very much for your reply.

I installed a new Joomla and only csvi 7.6.1 (test localhost) to see what is finally going on.

As you can see i have a new error message:

Status error: 200
Status message: OK

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\test\administrator\components\com_csvi\rantai\import\model.php on line 628

After that i can't test my csv to this test site.

Regards
Terry_K

Joomla!, 3.8.7
CSVI Pro 7.6.1
PHP/7.2.4
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Terry_K,
In your local XAMPP installation you need to look for parameter max_execution_time in your php.ini file and increase its value to solve the error.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Terry_K,
Before changing your php.ini file as i said in my previous reply, have a look at Manage timeout document and see if reducing lines per import in your import template settings solves the error.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Tharuna,

I set max_execution_time from 30 sec to 60 sec, 120sec, 180 sec but still nothing...
The same erroe message:
Status error: 200
Status message: OK

Fatal error: Maximum execution time of 180 seconds exceeded in C:\xampp\htdocs\test\administrator\components\com_csvi\rantai\import\model.php on line 628

Regards
Terry_K

Joomla!, 3.8.7
CSVI Pro 7.6.1
PHP/7.2.4
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello Terry_K,
Can you check my last reply? See if reducing lines per import in import helps you with the error.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Tharuna

I import 10 lines and it's ok! 10 lines to 112 sec. 110 lines about 30 minutes?

Regards
Terry_K
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello Terry_K,
10 lines of import then for 110 lines it takes 11 cycles. So for if one cycle it is around 2 minutes as per 112 seconds which comes to 22 minutes for 110 lines. For every cycle the code delays the execution for 5 seconds (as per the default set in template) which comes to around 55 seconds for 11 cycles. This is done because when the script restarts for the next cycle, the memory used is released which makes server not to touch its limits. Considering all these your 110 lines would have taken around 23 minutes.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Tharuna

Τhanks a lot for guidance. Εverything works fine to my test site.

Regards
Terry_K
  1. more than a month ago
  2. RO CSVI
  3. # 14
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!