Hello there! Welcome to Youjoomla Support Forums

We are Web Development Company specializing in Joomla Templates , Joomla Extensions and WordPress Themes development . You are not able to see some forum threads due to your memberhip level. To unlock all forums and special customer support please take few moments to signup . If you are just searching for free joomla templates , or free joomla extension support simply head to our Free Joomla Support forums and open a new thread. Our moderators will help you as soon as possible. To spead up the response time please take few seconds and go over forum rules

Have fun!

YJStudio

09-02-2010, 11:30 AM
# 1 (permalink)
LMICassie
Adding this module to the SOLUTIONS template and I'm getting the following error: DB function failed with error number 1146
Table 'abcd_dbase.jos_yjstudio' doesn't exist SQL=SELECT * FROM jos_yjstudio where video_status = 1

Not sure where to begin looking for solutions.
09-02-2010, 11:45 AM
# 2 (permalink)
jaycburton
Hi Cassie - Did the installation succeed successfully? It sounds as if it did not as some database table is missing.
09-02-2010, 11:50 AM
# 3 (permalink)
LMICassie
Yes, it gave me a successful install message.
09-02-2010, 11:55 AM
# 4 (permalink)
jaycburton
Okay, great. Have you looked at the database (using phpMyAdmin) to see if there is a table entitled "jos_yjstudio"?
09-02-2010, 01:10 PM
# 5 (permalink)
LMICassie
Okay, i'm in admin and i do not see a table. do we know how many fields it will require? what name to give the field? type? length/values1? default2? collation? attributes? NULL? Index? auto_increment? ???
09-02-2010, 01:12 PM
# 6 (permalink)
jaycburton
Here is the SQL to create it:

CREATE TABLE IF NOT EXISTS `jos_yjstudio` (
`id` int(11) NOT NULL auto_increment,
`video_file` varchar(100) NOT NULL,
`video_title` varchar(30) NOT NULL,
`video_desc` varchar(100) NOT NULL,
`video_thumb` varchar(100) NOT NULL,
`video_preview` enum('0','1') NOT NULL default '1',
`preview_width` int(100) NOT NULL,
`preview_height` int(100) NOT NULL,
`added_date` datetime NOT NULL,
`video_status` tinyint(1) NOT NULL,
`ordering` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
09-02-2010, 01:21 PM
# 7 (permalink)
LMICassie
Let me giver a try...

Making progress - now I get:
Notice: Undefined offset: 0 in /home/lwma/public_html/modules/mod_yj_studio/mod_yj_studio.php on line 70

Notice: Trying to get property of non-object in /home/lwma/public_html/modules/mod_yj_studio/mod_yj_studio.php on line 70

Notice: Undefined offset: 0 in /home/lwma/public_html/modules/mod_yj_studio/mod_yj_studio.php on line 77

Notice: Trying to get property of non-object in /home/lwma/public_html/modules/mod_yj_studio/mod_yj_studio.php on line 77

Notice: Undefined offset: 0 in /home/lwma/public_html/modules/mod_yj_studio/mod_yj_studio.php on line 77

Notice: Trying to get property of non-object in /home/lwma/public_html/modules/mod_yj_studio/mod_yj_studio.php on line 77
09-02-2010, 01:23 PM
# 8 (permalink)
jaycburton
HI - LOL Okay. In that case, I would drop that table you just created, download the extension again, and reinstall it. It should install everything needed for the database automatically.
Thread Tools
Display Modes

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

Members Login

Username
Password