Categories
View Replies (4)

Resolved Errors: 'Mixing of GROUP columns' and 'No run ID'

  1. itleenmenken
    itleenmenken
  2. RO CSVI
  3. Monday, 21 September 2015
  4.  Subscribe via email
Hello,

After each import I receive the following errors:

First, my web browser warns me that the forwarding page has not been set correctly.
After entering the URL field of my browser and pressing enter, I'm in my back-end again.
I then see the status of my last import:

First:
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=SELECT COUNT(`status`) AS `total`,`status`,`result` FROM `lmot_csvi_logdetails` WHERE `csvi_log_id` = 14 ORDER BY `csvi_logdetail_id`


Then a number of times:
No run ID has been found. This means that CSVI was not able to initialise the import or that the processes table is not available.


Please advise.

Thanks, Ralph

Joomla 3.4.4
VirtueMart 3.0.10
PHP 5.4.43
Database 6.1.2
0
Responses (4)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Ralph,

First, my web browser warns me that the forwarding page has not been set correctly.
No idea what that is, never seen anything as such. Do you have a screenprint of it?

The database version you posted here is the version of CSVI, not the version of MySQL I believe. I am interesting to see which MySQL version you have because this query you posted gives no error here.
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
itleenmenken
itleenmenken
Accepted Answer Pending Moderation
Hi Roland,

Please find screenshots enclosed (Dutch).
- browser error
- 2nd error
- system info

After the browser error, I retype (select) the URL and press Enter.
I then get the 2nd error. Import is succesful however.

Thanks in advance,

Kind regards,

Ralph
Attachments (3)
error1aftercsviimport.jpg error1aftercsviimport.jpg
error2aftercsviimport.jpg error2aftercsviimport.jpg
systeminfo.jpg systeminfo.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Ralph,

Now it is clear to me what you see happening. The redirect error is most likely due to the SQL error you see. The reason why you get this SQL error I think is because you have a very old database version. This version is from July 2007 (source). It is surprising your host is using such an old MySQL version while your PHP version is up-to-date. This is something you may want to check with your host to at least update to MySQL 5.1.

The import can be successful because the error is only related to store the log details of the import.
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
itleenmenken
itleenmenken
Accepted Answer Pending Moderation
Thank you Roland,

I will discuss this with my hosting provider.
Hopefully they will be able to update soon.

Kind regards,

Ralph
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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