Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Welcome to the Official Site of PHP-Fusion
Sign In
Not a member yet? Click here to register.
Navigation
9 Replies | Latest reply on 02-06-2018 15:28 by zizub
Ryan Stewart
Ryan Stewart Posted 7 years ago 43 posts

Help with infusion creation

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?

$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, 7 years ago
img682.imageshack.us/img682/7469/logo2vod.png
Expect stuff from me soon (:

9 Replies

Sort replies by
MarcusG
MarcusGPosted 7 years ago 181 posts
Any errors in the error log?
Ex Senior Dev.
Ryan Stewart
Ryan StewartPosted 7 years ago 43 posts
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
MarcusGPosted 7 years ago 181 posts
artist_id INT(11) DEFAULT '' NOT NULL,


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

artist_id INT(11) DEFAULT '0' NOT NULL,
Ex Senior Dev.
zizub
zizubPosted 5 years ago 102 posts
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
GillettePosted 5 years ago 338 posts
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>
[url]http://www.skpacman.com/downloads.php?cat_id=2&download_id=3
[/url]
KasteR
KasteRPosted 5 years ago 291 posts
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..
Gillette
GillettePosted 5 years ago 338 posts

Quote

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
KasteRPosted 5 years ago 291 posts
No problem, by the way, didn't realize this thread was hijacked lol. Oh well, good stuff here. :D
zizub
zizubPosted 5 years ago 102 posts
Thanks for the help

Actions

Sharing

More topics like this

You can view all discussion threads in this forum.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You cannot download attachments in this forum.
Ryan Stewart

Help with infusion creation
by Ryan Stewart Posted 7 years ago