Unable to add an issue to a title, receiving an error instead

For any questions/comments/suggestions regarding using and/or contributing to ComicBookDB.com

Moderators: DarthSkeptical, Fnord Serious, Chris, spid, Skyhawke, Darth Kramer, mikebo

User avatar
aaronmoish
Posts: 69
Joined: Sun Mar 14, 2010 7:45 pm

Unable to add an issue to a title, receiving an error instead

Postby aaronmoish » Sun Sep 30, 2018 3:12 am

A little bit ago, i changed a "reuse" title to Marvel Mangaverse: The Complete Collection (http://www.comicbookdb.com/title.php?ID=60908), but when I click "Add an Issue to This Title", I get this error - Query failed: SELECT * FROM Creator, Creator_Position WHERE creator_ID = cp_creatorID ORDER BY creator_lastname, creator_firstname - instead of being able to add any issue information. I tried this on a few other titles to make sure it wasn't an isolated incident, and I get the same error each time. Is anyone else having this problem?

User avatar
Soda
Posts: 191
Joined: Fri Jun 10, 2011 4:12 pm

Re: Unable to add an issue to a title, receiving an error instead

Postby Soda » Sun Sep 30, 2018 6:55 am

Seems the database is broken once again because I can't access any entry with issues in them. Instead I get this:

Query failed: SELECT * FROM ((Award_Entry INNER JOIN Award_Category ON ae_categoryID = ac_ID) INNER JOIN Award_Name ON ac_nameID = an_ID) WHERE ac_table = 'Title' AND ae_tableID = 60930 ORDER BY an_name, ae_year, ac_category

User avatar
aaronmoish
Posts: 69
Joined: Sun Mar 14, 2010 7:45 pm

Re: Unable to add an issue to a title, receiving an error instead

Postby aaronmoish » Sun Sep 30, 2018 7:24 am

I was having that issue, as well, plus errors clicking on Creators and Story Arcs, but those issues stopped a few minutes ago, as I was initially typing this. I'm still getting the same error for adding new issues, though. Since 8 of the titles in the "Last 10 titles added" list have any issues, it looks like it is not just me.

BamaRainbow
Posts: 7
Joined: Sat Jun 20, 2015 8:33 pm

Re: Unable to add an issue to a title, receiving an error instead

Postby BamaRainbow » Sun Sep 30, 2018 9:50 pm

Just one more chiming in. I've been having this problem all afternoon. I've been able to add variant covers and I've even entered "New Content" (in the way of new titles) but when I try to enter a new issue--even with the new titles I've added--I'm getting the same "Query failed" error.

Skattershot
Posts: 12
Joined: Sun Sep 04, 2011 8:14 pm

Re: Unable to add an issue to a title, receiving an error instead

Postby Skattershot » Mon Oct 01, 2018 2:30 am

I'm getting it myself as well. Last night it wasn't letting me add any issues to my collection, but that seemed to been fixed. Now I get the same error when adding new content as well.

User avatar
mikebo
Posts: 497
Joined: Thu Feb 07, 2008 5:56 am

Re: Unable to add an issue to a title, receiving an error instead

Postby mikebo » Mon Oct 01, 2018 8:02 pm

I let Chris know. With any luck it won't take too long to fix.

User avatar
Chris
Cosmic Donor
Cosmic Donor
Posts: 1090
Joined: Sun Nov 13, 2005 4:48 am
Location: Toronto
Contact:

Re: Unable to add an issue to a title, receiving an error instead

Postby Chris » Mon Oct 01, 2018 8:03 pm

Can you guys check now?

User avatar
aaronmoish
Posts: 69
Joined: Sun Mar 14, 2010 7:45 pm

Re: Unable to add an issue to a title, receiving an error instead

Postby aaronmoish » Tue Oct 02, 2018 2:11 am

All appear to be working fine now. Thanks, Chris!

Merrik Redux
Posts: 25
Joined: Fri Jun 22, 2018 7:22 pm

Re: Unable to add an issue to a title, receiving an error instead

Postby Merrik Redux » Fri Nov 09, 2018 8:48 am

While anyone's in the fixing mood :mrgreen:

Does someone want to take a crack at this:

Warning: mysql_connect(): User dbcomic_admin already has more than 'max_user_connections' active connections in /home/comicboo/include/config.php on line 52
Could not connect


Which I'm going to say happens at least a handful of times 85% of the time I'm on the site. Pops up out of nowhere at any given time, never a warning. Makes the simplest of tasks, like adding a group to an issue, time consuming. Makes tasks that take an abnormally long time anyway (such as editing creators or details of an issue) almost maddening. Tonight, it's taken me about 10 minutes to try and add three characters to a story. That warning has popped up every single time I try to add one. Or I'll try to select the character from the list but it will only highlight a blank gray space. Lots of refreshing, it finally goes away, try again... repeat over and over again.

It's the most frustrating when adding a new character and you've taken time to write up a decent biography or blurb about their powers and you go to submit and everything is lost because that warning pops up and you have to start again.

Any chance that can be looked into? :)

Merrik Redux
Posts: 25
Joined: Fri Jun 22, 2018 7:22 pm

Re: Unable to add an issue to a title, receiving an error instead

Postby Merrik Redux » Fri Nov 09, 2018 9:26 am

Also, apologies to whichever mod gets the duplicate submission for a character image I submitted tonight. The errors kept popping up and as I was refreshing it submitted the image more than once! Sincere apologies! :oops:


Return to “Site Support”

Who is online

Users browsing this forum: No registered users and 1 guest