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.
Not a member yet? Click here to register.
Forgot Password?

Help with infusion creation

Asked Modified Viewed 2,830 times
R
Ryan Stewart
R
img682.imageshack.us/img682/7469/logo2vod.png

Expect stuff from me soon (:
  • Junior Member, joined since
  • Contributed 42 posts on the community forums.
  • Started 6 threads in the forums
  • Started this discussions
asked
Junior Member

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 10:58,
0 replies

9 posts

Z
zizub
Z
zizub 10
  • Member, joined since
  • Contributed 156 posts on the community forums.
  • Started 29 threads in the forums
answered
Member

Thanks for the help
0 replies
K
KasteR
K
KasteR 10
  • Senior Member, joined since
  • Contributed 290 posts on the community forums.
  • Started 1 thread in the forums
answered
Senior Member

No problem, by the way, didn't realize this thread was hijacked lol. Oh well, good stuff here. :D
0 replies
G
Gillette
G
Gillette 10
  • Senior Member, joined since
  • Contributed 335 posts on the community forums.
  • Started 4 threads in the forums
answered
Senior Member

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
0 replies
K
KasteR
K
KasteR 10
  • Senior Member, joined since
  • Contributed 290 posts on the community forums.
  • Started 1 thread in the forums
answered
Senior Member

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..
0 replies
G
Gillette
G
Gillette 10
  • Senior Member, joined since
  • Contributed 335 posts on the community forums.
  • Started 4 threads in the forums
answered
Senior Member

here:

PHPFusion 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]
0 replies
Z
zizub
Z
zizub 10
  • Member, joined since
  • Contributed 156 posts on the community forums.
  • Started 29 threads in the forums
answered
Member

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 ?
0 replies
— 1 year earlier —
M
MarcusG
M
Ex Senior Dev.
  • Member, joined since
  • Contributed 182 posts on the community forums.
  • Started 5 threads in the forums
answered
Member

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,
0 replies
R
Ryan Stewart
R
img682.imageshack.us/img682/7469/logo2vod.png

Expect stuff from me soon (:
  • Junior Member, joined since
  • Contributed 42 posts on the community forums.
  • Started 6 threads in the forums
  • Started this discussions
answered
Junior Member

No, no errors are returned. As i've said it runs the first one fine, and creates the artists table.
0 replies
M
MarcusG
M
Ex Senior Dev.
  • Member, joined since
  • Contributed 182 posts on the community forums.
  • Started 5 threads in the forums
answered
Member

Any errors in the error log?
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 9 posts
  • Votes 0 votes
  • Topic users 5 members

5 participants

R
R
img682.imageshack.us/img682/7469/logo2vod.png

Expect stuff from me soon (:
  • Junior Member, joined since
  • Contributed 42 posts on the community forums.
  • Started 6 threads in the forums
  • Started this discussions
M
M
Ex Senior Dev.
  • Member, joined since
  • Contributed 182 posts on the community forums.
  • Started 5 threads in the forums
G
G
Gillette 10
  • Senior Member, joined since
  • Contributed 335 posts on the community forums.
  • Started 4 threads in the forums
Z
Z
zizub 10
  • Member, joined since
  • Contributed 156 posts on the community forums.
  • Started 29 threads in the forums
K
K
KasteR 10
  • Senior Member, joined since
  • Contributed 290 posts on the community forums.
  • Started 1 thread in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet