Skip to content

Cannot Create play list?

If you're experiencing problems with the website (packs pages/forum/wiki) or you would like to suggest something, you can post here.

Moderator: Staff

  • MstrVIRUS Offline
  • Posts: 2
  • Joined: 2019-12-16, 23:29:15

Cannot Create play list?

Post by MstrVIRUS »

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!

Post by vampirefrog »

Try now, chief.
  • MstrVIRUS Offline
  • Posts: 2
  • Joined: 2019-12-16, 23:29:15

Post by MstrVIRUS »

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] =>
)
Post Reply