11 years ago
6
Topic

Hello i just expirence a new Problem i have a big Multi Site that worked greate now i created once again a new sub site then there was a SQL error that i couldn't read complet then the site refreshed.

now when i go to MultiSite i get a Instand error as followed below only whanted to let you know that coz i couldn't imagin whats wrong there i looked the tables look existing.


An error has occurred.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SQL=SELECT COUNT(a.id) FROM zi0tk_cck_core AS a LEFT JOIN zi0tk_content AS b ON b.id = a.pk WHERE a.storage_location = "joomla_article" AND b.access IN (1,);


Get a Book for SEBLOD
572 Posts
_jrmo
11 years ago
3
Level 1

It's not Seblod's fault I don't think I also got this error recently when installing the newest version of Akeeba, I think.

11 years ago
0
Level 2

Ok The Site is using Akeeba but look at this SQL Statment what has it to do with it? Are you sure you got Exactly this Error?

548 Posts
joomleb
11 years ago
1
Level 2

I'm running Joomla+Seblod multisite+Akeeba, so I'm too interested on this issue, Do you mean Akeeba Backup ?

Are you working on this error?

11 years ago
0
Level 3

I Still got the Error and verifyed what i already got and its is Simply not Akeeba Related i removed the plugin and so on the error is probally a real fail in Seblod but i can't find the place where it happens i don't got the time to debug that all Day i simply stop using Multi Site Option and Installed Single Installations of Joomla that Solved the Problem ^^ and i don't think that any one is going to fix that since its not needed to get fixed ^^ all essential Funktions are Working but to stay Fair i should say i Simply use Joomla 3.1.5 and fixed some stuff my self

11 years ago
1
Level 1

Hi

use the multisite functionality and do not have this problem.

do not use Akeeba.

what version of joomla, seblod and mysql are you using?

11 years ago
0
Level 2

first of all thx for attention: i found out that the error msg now changed as i replaced my fixes with the original legacy.php from joomla 3.1.5 now i have a new error that is more clear it looks like there is something wrong with the user settings of one site ill repost a new post for that New Post to the current Problem ! i mark this one as solved!

Get a Book for SEBLOD