|
Help with infusion creation
|
| Ryan Stewart |
Posted on 05-06-2011 11:44
|
Junior Member
Posts: 45
Joined: 09/04/2010
|
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?
 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
Expect stuff from me soon (: |
| |
|
|
| MarcusG |
Posted on 06-06-2011 10:14
|
Admin
Posts: 189
Joined: 13/08/2010
|
Any errors in the error log?
Ex Senior Dev.
|
| |
|
|
| Ryan Stewart |
Posted on 06-06-2011 10:17
|
Junior Member
Posts: 45
Joined: 09/04/2010
|
No, no errors are returned. As i've said it runs the first one fine, and creates the artists table.
Expect stuff from me soon (:
|
| |
|
|
| MarcusG |
Posted on 06-06-2011 11:24
|
Admin
Posts: 189
Joined: 13/08/2010
|
Code artist_id INT(11) DEFAULT '' NOT NULL,
Numeral fields need numbers as default values, not a string.
Code artist_id INT(11) DEFAULT '0' NOT NULL,
Ex Senior Dev.
|
| |
|
|
| zizub |
Posted on 11-02-2013 22:14
|
Junior Member
Posts: 14
Joined: 02/05/2012
|
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 |
Posted on 12-02-2013 01:32
|
Admin
Posts: 291
Joined: 09/04/2012
|
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 |
Posted on 12-02-2013 02:42
|
Member
Posts: 152
Joined: 14/07/2012
|
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 |
Posted on 12-02-2013 03:11
|
Admin
Posts: 291
Joined: 09/04/2012
|
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 |
Posted on 12-02-2013 04:14
|
Member
Posts: 152
Joined: 14/07/2012
|
No problem, by the way, didn't realize this thread was hijacked lol. Oh well, good stuff here.  |
| |
|
|
| zizub |
Posted on 12-02-2013 14:15
|
Junior Member
Posts: 14
Joined: 02/05/2012
|
Thanks for the help |
| |
|
