vgmrips

The forum about vgm files
It is currently 2020-02-18, 14:32:31

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Cannot Create play list?
PostPosted: 2019-12-16, 23:40:37 
Offline

Joined: 2019-12-16, 23:29:15
Posts: 2
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!


Top
 Profile  
 
 Post subject:
PostPosted: 2019-12-29, 1:45:36 

Staff Staff
Programmers Programmers
Contributors Contributors
Ball Fondlers Ball Fondlers
Offline
User avatar

Joined: 2014-01-28, 5:51:54
Posts: 701
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.


Top
 Profile  
 
 Post subject:
PostPosted: 2020-01-03, 4:16:26 
Offline

Joined: 2019-12-16, 23:29:15
Posts: 2
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] =>
)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group
[ Time : 0.191s | 13 Queries | GZIP : On ]