× Joomla Facebook Connect support forum

Topic-icon Problem installing JFBConnect

Active Subscriptions:

None
15 years 4 months ago #6716 by cyrille
Hi,

I got the folowing DB error while installing JFBConnect component :
* JInstaller::install: Erreur SQL. DB function failed with error number 1146
          Table 'teamakrostyle.jos_jfbconnect_user_map' doesn't exist SQL=CREATE TABLE IF NOT EXISTS `jos_jfbconnect_user_map` ( `id` int unsigned NOT NULL auto_increment, `j_user_id` INT NOT NULL, `fb_user_id` BIGINT NOT NULL, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, PRIMARY KEY (`id`) );
          SQL =

          CREATE TABLE IF NOT EXISTS `jos_jfbconnect_user_map` (
          	`id` int unsigned NOT NULL auto_increment,
          	`j_user_id` INT NOT NULL,
          	`fb_user_id` BIGINT NOT NULL,
          	`created_at` DATETIME NOT NULL,
          	`updated_at` DATETIME NOT NULL,
          	PRIMARY KEY (`id`)
          );

        * Composant Installation: Erreur SQL ou fichier sql absent ou illisible. DB function failed with error number 1146
          Table 'teamakrostyle.jos_jfbconnect_user_map' doesn't exist SQL=CREATE TABLE IF NOT EXISTS `jos_jfbconnect_user_map` ( `id` int unsigned NOT NULL auto_increment, `j_user_id` INT NOT NULL, `fb_user_id` BIGINT NOT NULL, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, PRIMARY KEY (`id`) );
          SQL =

          CREATE TABLE IF NOT EXISTS `jos_jfbconnect_user_map` (
          	`id` int unsigned NOT NULL auto_increment,
          	`j_user_id` INT NOT NULL,
          	`fb_user_id` BIGINT NOT NULL,
          	`created_at` DATETIME NOT NULL,
          	`updated_at` DATETIME NOT NULL,
          	PRIMARY KEY (`id`)
          );

What do I have to do ?

Thanks
The topic has been locked.
Support Specialist
15 years 4 months ago #6726 by alzander
That's a good question. We've never seen that error before. The way we create tables is using a "CREAT TABLE IF NOT EXISTS" statement, which means that your database should check if the table exists first, and if not, actually execute the create statement. For some reason, your database is failing because the database doesn't exist, which is odd.

Can you let me know the following, and that may help us debug/diagnose the issue:
* Have you ever had JFBConnect installed (an earlier version)?
* Do you know what type of database you're using? MySQL? Do you know the version? This can usually be found in the Help->System Info area of your site.

Thanks!
The topic has been locked.
Active Subscriptions:

None
15 years 4 months ago #6741 by cyrille
Hi, I solved the problem by using "DROP TABLE IF EXISTS" statement.
I had a previous version of JFBConnect installed, maybe deinstallation didn't work properly.
The topic has been locked.
Support Specialist
15 years 4 months ago #6751 by alzander
That's strange. We intentionally don't drop the tables so that when you upgrade, your site keeps the previous configuration and connections between Joomla and Facebook. Hopefully, you won't run into this issue again, but thanks for the posting your solution!
The topic has been locked.