Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
Bug reports and fixes
.
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
General
(Moderators:
Ivan Trebješanin
,
Farhad Sakhaei
) »
Bubbles component not creating table on install ?
« previous
next »
Print
Pages: [
1
]
Author
Topic: Bubbles component not creating table on install ? (Read 5700 times)
ROUBOS
Hero Member
Posts: 699
Bubbles component not creating table on install ?
«
on:
July 14, 2010, 16:33:36 »
Hi,
after installing the IOS Bubbles component, I get an error:
URI: index.php?option=com_bubbles&Itemid=54
Message: Table 'fmlifegr_db.elx_bubbles' doesn't exist
from what I understand the table cannot be found. And when looking at the database tables in phpMyAdmin there is no such table in the database.
How can I fix this?
thanks
Note: the installations works, just when visiting the page on the site I get the error
«
Last Edit: July 14, 2010, 18:30:46 by ROUBOS
»
Logged
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Bubbles component not creating table on install ?
«
Reply #1 on:
July 14, 2010, 21:38:50 »
Go to phpmyadmin, select your database from the left menu and click the "SQL" tab on the right.
Copy-paste the following command and click execute.
CREATE TABLE `elx_bubbles` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`message` text,
`parent` int(11) NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`username` varchar(80) default NULL,
`author` varchar(120) default NULL,
`dateadded` datetime NOT NULL default '1979-12-19 00:00:00',
`attachment` varchar(250) default NULL,
`ipaddress` varchar(64) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Change Engine from MyISAM to InnoDB if you use that database engine.
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
ROUBOS
Hero Member
Posts: 699
Re: Bubbles component not creating table on install ?
«
Reply #2 on:
July 14, 2010, 21:55:01 »
Thank you so much. That fixed one part, once I write a new topic, I get a new page not found error, after the refresh it displays it.
What was causing it? It's like that error I get for the Shouter module.
Is there an issue with the database access?
Does this have anything to do with it? InnoDB cache hit ratio 0 Cache ratio should be at least 90%
«
Last Edit: July 14, 2010, 22:05:54 by ROUBOS
»
Logged
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Bubbles component not creating table on install ?
«
Reply #3 on:
July 14, 2010, 22:04:00 »
For some reason the schema file did not executed during install. Elxis might showed you an error during install but you did nt paid attention to it. After that command everything is ok.
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
ROUBOS
Hero Member
Posts: 699
Re: Bubbles component not creating table on install ?
«
Reply #4 on:
July 14, 2010, 22:06:19 »
getting:
Error 404
We are sorry but the page you requested was not found.
/com_bubbles/1.html
What about this?
InnoDB cache hit ratio 0 Cache ratio should be at least 90%
URI: index3.php?option=com_database&task=monexec&do=stats
Message: Access denied; you need the SUPER privilege for this operation
show innodb status
«
Last Edit: July 14, 2010, 22:19:41 by ROUBOS
»
Logged
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Bubbles component not creating table on install ?
«
Reply #5 on:
July 14, 2010, 22:20:21 »
It's ok. Nothing to worry about.
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
ROUBOS
Hero Member
Posts: 699
Re: Bubbles component not creating table on install ?
«
Reply #6 on:
July 14, 2010, 22:23:47 »
why do i get this message:
Error 404
We are sorry but the page you requested was not found.
/com_bubbles/1.html
Logged
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Bubbles component not creating table on install ?
«
Reply #7 on:
July 14, 2010, 22:35:31 »
The SEO PRO extension could not be copied during install to the includes/seopro/ directory.
Copy this file:
administrator/components/com_bubbles/seopro.com_bubbles.php
Here:
includes/seopro/com_bubbles.php
Note that you have to rename the copied file from
seopro.com_bubbles.php
to
com_bubbles.php
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
ROUBOS
Hero Member
Posts: 699
Re: Bubbles component not creating table on install ?
«
Reply #8 on:
July 14, 2010, 23:11:56 »
so this might be the problem with Shouter as well? Do the same? What names?
thanks for the help
Logged
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Bubbles component not creating table on install ?
«
Reply #9 on:
July 14, 2010, 23:48:49 »
Shouter is a module, it does not have a SEO PRO extension.
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
ROUBOS
Hero Member
Posts: 699
Re: Bubbles component not creating table on install ?
«
Reply #10 on:
July 15, 2010, 00:27:13 »
thanks. That did it.
Shouter gives me this error:
Error 404
We are sorry but the page you requested was not found.
/index.php
I place this module on an autonomous page.
I would prefer to have shouter working as I already have the eForum component
Logged
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Support
»
General
(Moderators:
Ivan Trebješanin
,
Farhad Sakhaei
) »
Bubbles component not creating table on install ?