vampirefrog wrote:
Try now, chief.
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] =>
)