Categories
View Replies (27)

Resolved Product Export throwing database table error

  1. batetim
    batetim
  2. RO CSVI
  3. Wednesday, 11 March 2015
  4.  Subscribe via email
Hi Roland

Running csvi 5.2 on Joomla 3.4.0, VM 3.0.6.2

Have created product export template which we use for google shopping xml feed. (set up as attached)

Export is failing and throwing up error message as below:

1146 Table 'ondirect-g.hal3m_virtuemart_products_' doesn't exist SQL=SELECT `hal3m_virtuemart_products`.* ,`hal3m_virtuemart_products_`.* FROM `hal3m_virtuemart_products` INNER JOIN `hal3m_virtuemart_products_` using (`virtuemart_product_id`) WHERE `hal3m_virtuemart_products`.`virtuemart_product_id` = "1200"

Kind regards

Tim
0
Responses (27)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Table 'ondirect-g.hal3m_virtuemart_products_'
This indicates you have not chosen a language on the Options tab. Select the appropriate language and save the template, run your export again after that.
Kind regards,

RolandD

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

We just have the one option on options>primary language which is currently set at English (en-GB).

Just selected and saved again, but same error message i am afraid

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

I jumped the gun a little on that, I see now that it is not a CSVI query giving the error but a VirtueMart one. This has been posted before and turned out something changed in VirtueMart causing that error.

I just released CSVI 5.21 that includes a fix for that. Can you give it a try and let me know?
Kind regards,

RolandD

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

Just uploaded and has thrown attached sql error message on csvi installation

Kind regards

Tim
Attachments (1)
Doc2.docx
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Don't know where that comes from as I didn't get that here on an update. What you can do is close the screen and go to Components -> CSVI Pro -> Available Fields -> Update. That is enough to update the fields. You can import/export after that.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
batetim
batetim
Accepted Answer Pending Moderation
Hi Roland, throws same error message although it may have updated anyway?? (see attached)
Attachments (1)
Doc3.docx
  1. more than a month ago
  2. RO CSVI
  3. # 6
batetim
batetim
Accepted Answer Pending Moderation
... not sure it helps, but this is the error message from our server log

officeneedsdirect.co.uk [Wed Mar 11 14:45:18 2015] [error] [client 109.146.169.10:55513] Invalid status line from script 'index.php': 0 SQL=
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
The problem that you see is that it tries to execute an SQL query but there is no query to execute. That makes it so weird, it could be a parsing issue, that it thinks there is another query to execute while it is an empty line. Just guessing from the top of my head. Updating the available fields can be done via the steps explained earlier. This second step is sort of a quick link to it.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
batetim
batetim
Accepted Answer Pending Moderation
... do you need any more info from me to help?

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

I wasn't aware you were waiting for me. The CSVI 5.21 version should deal with your import problem, doesn't it?

As for the installation error, this isn't a problem or you get it also when you run the update available fields?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
batetim
batetim
Accepted Answer Pending Moderation
Hi Roland

I am afraid it does show the same error message from update available fields

0 SQL=

The export is working now, but fails half way through and i wondered if it was linked to the above issue and csvi has not updated to 5.21 correctly

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 11
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Sorry, I didn't realize that. What you can do is to uninstall CSVI via the Extension Manager and then install again. This will keep your templates but cleans up the filesystem. You could give that a try.

As for the export, if it fails half way, it is another issue unrelated to the update. Is there an error in the export file or it just stops exporting? In the latter case it might be the server just stopping the export because it takes too long.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
batetim
batetim
Accepted Answer Pending Moderation
Hi Roland

Unfortunately uninstall and reinstall still generated same error message on installation.

As for export, after a period of time just goes white screen as attached and creates a partial xml file of about 7.6MB. Dont think it can be the max execution time as we have this set as max_execution_time = 300 and its not getting that far

Kind regards

Tim
Attachments (1)
Doc1-3.docx
  1. more than a month ago
  2. RO CSVI
  3. # 13
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Let's check the update issue later and focus on the export.

The white screen you posted is a typical fatal error with error reporting turned off. If it is not the execution time it might be the memory. The only way to know for sure is to see the error.

Go to System -> Global Configuration -> Server -> Error reporting and set this to Simple. Save the configuration and then run the export and see if you get to see the error. If not, increase it to Maximum.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
batetim
batetim
Accepted Answer Pending Moderation
yes, simple settings has worked and it brings up

Fatal error: Out of memory (allocated 225705984) (tried to allocate 130968 bytes) in /home/cluster-sites/1050/o/http://officeneedsdirect.co.uk/public_html/libraries/joomla/database/driver/mysqli.php on line 1038

We do however have our memory_limit set at 800M as you can see on our http://www.officeneedsdirect.co.uk/info.php page

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 15
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Chris,

It is not CSVI who decides when you run out of memory, it is the server itself. Have a look at this StackOverflow post for example. It turned out to be a setting in the httpd.conf file. So you may want to check that as well.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 16
roadhunt
roadhunt
Accepted Answer Pending Moderation
Hi Roland

I installing CSVI 5.21 and same error message.

0 SQL=



Kind regards
  1. more than a month ago
  2. RO CSVI
  3. # 17
rolandd
rolandd
Accepted Answer Pending Moderation
Sorry guys, it was a stupid space at the end of a file. Who would have known :ohmy:

This is fixed in version 5.21.1 available from the Downloads.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 18
batetim
batetim
Accepted Answer Pending Moderation
thanks Roland, appreciate the advice!

5.211 installed fine :)

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 19
batetim
batetim
Accepted Answer Pending Moderation
Hi Roland

I have been looking into getting the RLimitMEM extended with our host to allow this export to work, and although we have made some headway i am still struggling to export the entire product range for Google shopping as an XML file.

On imports there is the ability to break the import lines down into smaller chunks, is there any similar procedure that can be done for exporting? As our host server keeps throwing an internal server error message at about 9.5MB xml file which is only part way through

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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