Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Navigation
Follow us on Facebook
Follow us on Google+
View Thread
Official Home of PHP-Fusion » General Addon and Modification Support » Modifications and Requests
Who is here? 1 guest(s)
 Print Thread
Help with infusion creation
Ryan Stewart
I'm deprived of sleep right now, so I am not quite sure what i've done wrong here. It creates the first table fine, but that's about it. Any help?

Download source  Code
$inf_newtable[1] = ARTISTS." (

artist_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,

artist_name VARCHAR(70) DEFAULT '' NOT NULL,

artist_bio TEXT DEFAULT '' NOT NULL,

artist_record_company VARCHAR(150) DEFAULT '' NOT NULL,

PRIMARY KEY (artist_id)

) TYPE=MyISAM;";

$inf_newtable[2] = ALBUMS." (
artist_id INT(11) DEFAULT '' NOT NULL,
album_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
album_name VARCHAR(70) DEFAULT '' NOT NULL,
album_tracks SMALLINT(5) NOT NULL,
PRIMARY KEY (album_id)
) TYPE=MyISAM;";

$inf_newtable[3] = PLAYLISTS." (
playlist_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT(8) DEFAULT '' NOT NULL,
playlist_name VARCHAR(70) DEFAULT '' NOT NULL,
playlist_date INT(10) DEFAULT '' NOT NULL,
playlist_modified INT(10) DEFAULT '' NOT NULL,
PRIMARY KEY (playlist_id)
) TYPE=MyISAM;";

$inf_newtable[4] = PLAYLISTS_ITEMS." (
playlist_id INT(11) DEFAULT '' NOT NULL,
track_id INT(11) DEFAULT '' NOT NULL
) TYPE=MyISAM;";

$inf_newtable[5] = TRACKS." (
track_id INT(11) DEFAULT '' NOT NULL AUTO_INCREMENT,
artist_id INT(11) DEFAULT '' NOT NULL,
track_name VARCHAR(70) DEFAULT '' NOT NULL,
track_url VARCHAR(150) DEFAULT '' NOT NULL,
PRIMARY KEY (track_id)
) TYPE=MyISAM;";




Merged on Jun 06 2011 at 09:58:13:
Seriously? Does no one have any idea? I lost a whole day of development work yesterday due to this...
Edited by Ryan Stewart on 06-06-2011 09:58
img682.imageshack.us/img682/7469/logo2vod.png
Expect stuff from me soon (:
 
MarcusG
Any errors in the error log?
Ex Senior Dev.
 
http://phpfusion.marcusg.de
Ryan Stewart
No, no errors are returned. As i've said it runs the first one fine, and creates the artists table.
img682.imageshack.us/img682/7469/logo2vod.png
Expect stuff from me soon (:
 
MarcusG
Download source  Code
artist_id INT(11) DEFAULT '' NOT NULL,




Numeral fields need numbers as default values, not a string.

Download source  Code
artist_id INT(11) DEFAULT '0' NOT NULL,



Ex Senior Dev.
 
http://phpfusion.marcusg.de
zizub
I'm looking for an article or a guide how to create your Infusions plugin. There is a instruction or not ? I need to know what files are to be created. I looked ready plugins but there a lot of unnecessary files to me and I can not figure out which I need the is required to use and which to ignore. Where to read about it ?
 
Gillette
here:

PHP-Fusion 7 Infusion SDK v1.00

With this small package of software, you can start building your own infusions, the right way. From small one-liners to entire systems, it all starts here.

located at skpacman.com>
http://www.skpacm...nload_id=3
 
KasteR
If you're using MySQL 5.5.8, then you should change TYPE=MyISAM to ENGINE=MyISAM. Perhaps that may have something to do with it as well..
 
http://kaster.us
Gillette
KasteR wrote:

If you're using MySQL 5.5.8, then you should change TYPE=MyISAM to ENGINE=MyISAM. Perhaps that may have something to do with it as well..


Good point,thanks for mentioning that Kaster
 
KasteR
No problem, by the way, didn't realize this thread was hijacked lol. Oh well, good stuff here. Grin
 
http://kaster.us
zizub
Thanks for the help
 
Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
Suggestion: Twitch Infusion Modifications and Requests 4 18-04-2014 10:25
Articles - Wiki (Infusion) Roadmap 61 27-02-2014 05:15
Video Infusion PRO Official releases [Infusions] 11 22-02-2014 20:34
Video Infusion PRO - Last video center panel Panels and Infusions 3 22-01-2014 11:11
Infusions Error During Infusion FAQ Panels and Infusions 1 21-01-2014 04:41
Official Home of PHP-Fusion uses cookies. Some may already have been set. Read more about our Cookies here.
Please click the button I Consent Cookies to hide this bar and accept our cookies. If you continue to use the site with no action taken, we'll assume that you consent our cookies anyway.
Cookiebar Panel fromVenue