0

I get the follow Error 1146 Message:

Table 'system.qbruw_extensions' doesn't exist SQL=SELECT * FROM qbruw_extensions WHERE element='com_imageshow' AND type='component

Reinstall of the component doesn't fix the Problem.

qbruw_extensions is existing in the Joomla MySQL Database

com_imageshow Folder is existing in the Components Folder of Joomla

Joomla Database repair doesn't fix the problem.

Joomla 3.4.1 is installed...

Jay Blanchard
  • 34,243
  • 16
  • 77
  • 119
Attix2508
  • 5
  • 1
  • 5
  • 2
    It looks like you haven't selected the right database. It assumes you want to work in the `system` database, which is probably not the case. Change to the proper database. – Jay Blanchard Apr 01 '15 at 15:10
  • i got a "system" database - but this was never used for joomla. Joomla Database is called "dbjoomla". The Joomla Backend is right configur'd to use "dbjoomla". There can i change it ? – Attix2508 Apr 01 '15 at 15:21
  • `SELECT table_name FROM information_schema.tables WHERE table_schema = 'system' AND table_name = 'qbruw_extensions';` – mysqlrockstar Apr 01 '15 at 15:27
  • Is the `qbruw_extensions` table in that database? What happens if you write `FROM dbjoomla.qbruw_extensions`? – Jay Blanchard Apr 01 '15 at 15:27
  • what is this component ? its a public extension ? can you give me the link ? – Silverboy.ir Apr 01 '15 at 15:36
  • @Rockstar - the system.qbruw_extensions dosn't exist in the system Database... Maybe how can i'm tell this the Joomla or the Database, that it have to use the dbjoomla.qbruw_extensions – Attix2508 Apr 01 '15 at 15:42
  • @Silverboy JSN ImageShow from joomlashine.com – Attix2508 Apr 01 '15 at 15:44
  • and in which page you are getting the error ? – Silverboy.ir Apr 01 '15 at 15:48
  • I include a PHP Script via "Nonumber Sourcerer Extentsion" in a normal article. This article is binded to the a main menu field in the frontend. – Attix2508 Apr 01 '15 at 16:12
  • I copy'd the qbruw_extensions into the system database -> Now i get the next missing table... There can i change this that joomla have to use his own "dbjoomla" Database and not the "system" database ? – Attix2508 Apr 01 '15 at 16:39

1 Answers1

0

Try this

SELECT * FROM dbjoomla.qbruw_extensions WHERE element='com_imageshow' AND type='component'

Solution : For next missing table

Either you export all the required tables from dbjoomla and import those into system database

OR

Use JDatabaseDriver->getInstance method to connect external database

mysqlrockstar
  • 2,536
  • 1
  • 19
  • 36
  • It's there... but why try joomla to read the table from system.qbruw_extensions ? it have to use dbjoomla.qbruw_extensions :/ – Attix2508 Apr 01 '15 at 16:20
  • I copy'd the qbruw_extensions into the system database -> Now i get the next missing table... There can i change this that joomla have to use his own "dbjoomla" Database and not the "system" database ? – Attix2508 Apr 01 '15 at 16:39