Elxis CMS Forum

Extensions => Components => Topic started by: oisy on February 08, 2011, 11:31:01

Title: {solved} IOS BUBBLES-no database
Post by: oisy on February 08, 2011, 11:31:01

Hi
I just install IOS Bubbles,
but when I connect it to the site it gives me this warning:

Quote

MYSQL [1146] execute:
URI: index.php?option=com_bubbles&Itemid=72
Message: Table 'simorone_sait.elx_bubbles' doesn't exist
SELECT id, title, uid, username, author, dateadded, ipaddress FROM elx_bubbles WHERE parent='0' ORDER BY dateadded DESC LIMIT 0,10

Does anyone have this problem? How to solve it?

Title: Re: IOS BUBBLES-no database
Post by: webgift on February 08, 2011, 14:53:01

You have changed the prefix of tables at database. haven't you?
This error tell you that there is no table named  : simorone_sait.elx_bubbles.

Title: Re: IOS BUBBLES-no database
Post by: oisy on February 08, 2011, 15:18:22

I haven't change anything to the SQL

This is the first time installing Bubbles to this site.

I try to reinstall it but it gives the same  Error.

Title: Re: IOS BUBBLES-no database
Post by: webgift on February 08, 2011, 15:19:57

Only giving me access i can check and fix it.
If you like send me FTP and administrator access via Personal Message (PM).

Title: Re: IOS BUBBLES-no database
Post by: datahell on February 08, 2011, 22:01:07

Maybe you have short open tags enabled that prevents XML files with XML prologue to be parsed correctly.
I removed XML prologue from the bubbles schema files and also added a Bulgarian translation.
Please re-download Bubbles from EDC (http://www.elxis-downloads.com/downloads/forums/120.html) and try to install it again.

Note: if you have short_open_tags enabled you will face more errors in other areas of the system (like on RSS). I strongly advice you to disable this bad setting in your server's php.ini (contact your web hosting provider or use an htaccess admin flag if possible).

Title: Re: IOS BUBBLES-no database
Post by: oisy on February 08, 2011, 22:17:36

Doesn't work again.

See here: http://simoron.eu/index.php?option=com_bubbles&Itemid=75
 this is what it shows.

I will contact my web hosting provider.

Thank's!

Title: Re: IOS BUBBLES-no database
Post by: datahell on February 08, 2011, 22:25:07

Create the table manually then...
Go to phpmyadmin, select your database from the left column, click on the "SQL" tab and write inside it:

Code: [Select]

CREATE TABLE  `simorone_sait`.`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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
Click execute to create the database table and you are ready.

Title: {solved} Re: IOS BUBBLES-no database
Post by: oisy on February 08, 2011, 22:29:57

This way works.

Thank you for the help!

<<<solved>>>