vgmrips

Greetings everyone!

I apologize if this has been discussed elsewhere but if it has, please link me to it.

Anyways, I have decided to create an account so I can start saving playlists via the site but no matter
what kind of combinations of characters & digits, or just digits OR characters, saving a playlist will give me this error.

Exception caught: MySQL error: Incorrect integer value: '' for column `vgmrips_vgmrips`.`rip_playlists`.`private` at row 1 "INSERT INTO `rip_playlists` (`phpbb_user_id`, `name`, `private`) VALUES('1239','LOOPINGPLAY','')"

Has there been a fix in progress or the workaround is to just save all .vgm's instead?

Thanks!

Try now, chief.

_________________
Follow me on twitter.

If you like this post, give it a big thumbs up and hit that subscribe button down below! And as always, thanks for reading, and see you next post.

This is it, chief! Your efforts have resolved this issue of being unable to create personal playlists! Much appreciated on that part!
[big thumbs up]

However, there's an odd issue encountered with deleting playlists. I am able to create multiple playlists and delete all but one playlist.
I can keep my private [Favorites] Playlist and 1 Public Playlist, but cannot delete said Public playlist.
It's not an issue for me, since I am able to create and add to playlists as originally desired, but here's the details regarding said issue.
[hr]
Exception caught: MySQL error: Cannot delete or update a parent row: a foreign key constraint fails (`vgmrips_vgmrips`.`rip_playlist_songs`, CONSTRAINT `FK_rip_playlist_songs_rip_playlists_id` FOREIGN KEY (`playlist_id`) REFERENCES `rip_playlists` (`id`)) "DELETE FROM rip_playlists WHERE phpbb_user_id = '1239' AND id = '384'"

Exception Object
(
[message:protected] => MySQL error: Cannot delete or update a parent row: a foreign key constraint fails (`vgmrips_vgmrips`.`rip_playlist_songs`, CONSTRAINT `FK_rip_playlist_songs_rip_playlists_id` FOREIGN KEY (`playlist_id`) REFERENCES `rip_playlists` (`id`)) "DELETE FROM rip_playlists WHERE phpbb_user_id = '1239' AND id = '384'"
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /var/www/vgmrips/public_html/packs/include/MyMySQLi.php
[line:protected] => 53
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/vgmrips/public_html/packs/include/PackModel.php
[line] => 1029
[function] => query
[class] => MyMySQLi
[type] => ->
[args] => Array
(
[0] => DELETE FROM rip_playlists WHERE phpbb_user_id = '1239' AND id = '384'
)

)

[1] => Array
(
[file] => /var/www/vgmrips/public_html/packs/pages/playlists.php
[line] => 15
[function] => deletePlaylist
[class] => PackModel
[type] => ->
[args] => Array
(
[0] => 1239
[1] => 384
)

)

[2] => Array
(
[file] => /var/www/vgmrips/public_html/packs/index.php
[line] => 99
[args] => Array
(
[0] => /var/www/vgmrips/public_html/packs/pages/playlists.php
)

[function] => include
)

)

[previous:Exception:private] =>
)