PlaystationTrophies Got a news tip? tips@x360a.org
Username
Password
 

Go Back   XboxAchievements.com > Main Hub > Feedback
Subscribe    Donate

Reply
 
Thread Tools Display Modes
Old 09-15-2008, 07:50 PM   #1
The Pants Party
You're Not Invited
 
The Pants Party's Avatar
 
Join Date: Feb 2006
Location: Westland, Michigan
Posts: 17,082

Za Pantsupati's Gamercard

Awards Showcase Road Map - Diamond   Staff - Super Moderator   Micro Guide - Platinum   15,000 Posts   Staff Club - Never Final   Staff Club - Minty   Staff Club - Shiftie   Staff Club - The Pants Party   Staff Club - AOS Puck   Arcade Crazy - Bronze   Over Achiever - Gold   Referrals - Gold
Total Awards: 20 (more» ...)
Problems with a My360Achievements Checklist? Post here. (READ FIRST POST!!!)

Ok, I decided to make a new one of these so I could have all the many solutions up front that will hopefully help people before they even need to post. If you don't even know how to enable lists or use this feature in general, please see this thread.

*******Essentially the fix for almost everything is just to delete the problematic checklist, re-enable it, and recheck everything.*******

NOTE: Disabling is different from deleting. To delete a list, hit the Red X from the "My Checklists" page. If you simply disable the list (inside the game's checklist), it won't solve anything. Here is a picture of where you need to click to delete a list.

1. Secret Achievements do not stay checked.
Well, this is an easy fix, but you will need to let me know what game is broken. There is an option in games under the admin system that says "Secret Achievements" and the default is 0 for no. When an achievement list is added that contains secrets we are supposed to go in and change the value to 1 for yes, but we don't always remember and the secrets will not save without that value changed. Once you let me know what game is broken I just have to change the value and it will work.

2. You say you fixed the above problem but the list still won't save!
If this is the case, please simply delete your checklist by hitting the Red X from the main list of checklists, then re-enable it and re-check everything. I apologize that this is the best fix, but it is.

3. I check an achievement and save, then it checks a different achievement.
This problem occurs when a game gets DLC achievements added that are secret. We don't know why it happens or how to fix it, but when we add secret achievements to a game after the original list has been imported, the list breaks completely for anyone who has been using it before the new achievements were added. Again, you will need to delete the checklist and re-enable it. And again, we are very sorry that this is the case, but it is.

4. My browser timed out/the site crashed while saving a checklist.
If this happens, the list will think it has received the data, updating your score, but not keeping the achievements checked off or it will check the achievements but not update your score. Again, deleting and re-enabling is the only fix. (This problem is much rarer now that it was previously, but just in case.)

5. I get an SQL error anytime I try to save achievements.
This was caused by some coding work we had done to speed up the saving process. Unfortunately the only fix is again to delete the checklist, then re-enable and recheck everything. This error will not occur in the future, but any games affected by the original mistake will need to be fixed.

6. DLC Achievements do not save.
When we add DLC achievements to a list, it becomes unusable if you had been using it before the DLC was added. We unfortunately can not find the cause, but again it is an easy fix of deleting the list, re-enabling it and rechecking everything.
__________________
~Alan | Anime | Books | TV | Twitter



I award you no points, and may God have mercy on your soul.

Last edited by The Pants Party; 07-28-2011 at 07:53 PM.
The Pants Party is offline   Reply With Quote
Old 09-24-2008, 06:39 AM   #2
Agent Aero
 
Agent Aero's Avatar
 
Join Date: Apr 2008
Location: London, England
Posts: 2,278

Aero x360a's Gamercard

Awards Showcase Submit - Gold   x360a Representer   Over Achiever - Bronze   Achievement Guide - Silver   Road Map - Gold   Word of Mouth   1,000 Posts   Donator - Level 1
Total Awards: 8 (more» ...)
Well before i buy a game i check of the achievements im probably likely to get and iv done this with bioshock and in my checklists it says 0/1100, but iv ticked around 850/1100 and done it twice.Just thought id let you know.
__________________
Agent Aero is offline   Reply With Quote
Old 09-24-2008, 07:17 PM   #3
Andrew x360a
Guide Team
 
Andrew x360a's Avatar
 
Join Date: Oct 2007
Location: Lexington VA
Posts: 1,881

Andrew x360a's Gamercard

Awards Showcase Staff Club - Shinobi273   Brick Builders & Busters Franchise Club - Tier 2   Staff Club - Minty   Staff Club - Andrew x360a   Can This Make Phone Calls? Challenge Club - Tier 2   Can This Make Phone Calls? Challenge Club - Tier 1   Staff - Guide Team   Staff Club - DEG23   Adhere to the Creed Franchise Club - Tier 1   Subscriber - Bronze   Brick Builders & Busters Franchise Club - Tier 1   Over Achiever - Silver
Total Awards: 21 (more» ...)
Quote:
Originally Posted by The Pants Party View Post
2. You say you fixed the above problem but the list still won't save!
If this is the case, please simply delete your checklist by hitting the Red X from the main list of checklists, then re-enable it and re-check everything. I apologize that this is the best fix, but it is... here is a picture of where you need to click to delete a list.
Hey Pants, just to clarify for people like me who don't seem to be able to follow instructions exactly, clicking "Disable MyAchievements" while you're actually in a particular game's checklist is not the same as clicking the Red X from the general list of games. The Disable MyAchievements option will not fix this problem.
__________________


Staff Clubs: [4]
Challenge Clubs: Tier One [3], Tier Two [2], Tier Three [0]

Working On: Troy's Club and Knife in the Dark Tier One
Andrew x360a is offline   Reply With Quote
Old 10-08-2008, 01:52 AM   #4
uberviolence
 
Join Date: Jan 2008
Posts: 5

uberviolence's Gamercard
I'm having trouble with the checklists (obviously)

They don't seem to recognise sometimes when I've checked things (i.e, I check them off and save and when I go back the ones I just saved aren't saved)
I have tried the deleting the checklist and starting again but it doesn't seem to work.
This also happens on new games (one's I've not checked anything off on before and only just added to my checklists)

The other issue I have is that when I click save it's REALLY slow saving (been waiting about 5 mins for it to save my achievements for Battlefield:BC now, usually it's anywhere between 2-5 mins)

All other sites load as they should, I'm using Windows Vista and the same problem seems to occur in IE, Firefox and Chrome, please help me work out why it's like surfing on dial-up when I use the site
uberviolence is offline   Reply With Quote
Old 10-08-2008, 02:54 AM   #5
Siegfried
 
Siegfried's Avatar
 
Join Date: Apr 2007
Posts: 653
Send a message via MSN to Siegfried

SiegfriedX's Gamercard

Awards Showcase Over Achiever - Gold
Total Awards: 1 (more» ...)
Yeah, my list is incredibly slow today as uberviolence said.

All sections of the site load OK, my games list loads ok, but when I click on a game to open the achievement list or add an achievement and try to save, it's taking more than 10 minutes.
__________________


Siegfried is online now   Reply With Quote
Old 10-08-2008, 10:41 PM   #6
Rushy
 
Rushy's Avatar
 
Join Date: Dec 2007
Posts: 12

Rushy UK's Gamercard
Same for me, been unable to use my lists at all for the past few days. Everything else is fine.
Rushy is offline   Reply With Quote
Old 10-12-2008, 08:04 PM   #7
Kal-El814
 
Kal-El814's Avatar
 
Join Date: May 2008
Location: Boston area
Posts: 15

KalEl814's Gamercard
Checklists are taking a long time for me as well. To enable them for a game, check and save it's probably taking upwards of 15 minutes per game.
Kal-El814 is offline   Reply With Quote
Old 10-17-2008, 09:19 PM   #8
emirP sumitpO
 
Join Date: Nov 2007
Posts: 30

x Quikbaud x's Gamercard
Quote:
Originally Posted by Kal-El814 View Post
Checklists are taking a long time for me as well. To enable them for a game, check and save it's probably taking upwards of 15 minutes per game.
same here and this isn't something that just started happening it's been happening for awhile now. is there any reason it does this. It's every list of every game that this happens on when i save a list. Everything else is fast and every other site is fast it's just that checklist save that is uber slow!
emirP sumitpO is offline   Reply With Quote
Old 10-29-2008, 05:48 AM   #9
fantom88
 
fantom88's Avatar
 
Join Date: Jun 2008
Location: Alberta, Canada
Posts: 39

pwnseidon's Gamercard

Awards Showcase Submit - Bronze   Donator - Level 1
Total Awards: 2 (more» ...)
Hi, the secret achievements for Guitar Hero: World Tour are not staying checked. Thanks.
fantom88 is offline   Reply With Quote
Old 10-29-2008, 03:53 PM   #10
fantom88
 
fantom88's Avatar
 
Join Date: Jun 2008
Location: Alberta, Canada
Posts: 39

pwnseidon's Gamercard

Awards Showcase Submit - Bronze   Donator - Level 1
Total Awards: 2 (more» ...)
Hi, the new achievement for Marble Blast Ultra will not update. Thanks. It is called "Blue Gem Hunt"
fantom88 is offline   Reply With Quote
Old 10-29-2008, 04:16 PM   #11
The Pants Party
You're Not Invited
 
The Pants Party's Avatar
 
Join Date: Feb 2006
Location: Westland, Michigan
Posts: 17,082

Za Pantsupati's Gamercard

Awards Showcase Road Map - Diamond   Staff - Super Moderator   Micro Guide - Platinum   15,000 Posts   Staff Club - Never Final   Staff Club - Minty   Staff Club - Shiftie   Staff Club - The Pants Party   Staff Club - AOS Puck   Arcade Crazy - Bronze   Over Achiever - Gold   Referrals - Gold
Total Awards: 20 (more» ...)
Fixed GHWT. The MBU achievements probably fall under #3, try deleting and re-enabling the list.

Also, speeds should be much better now from the maintenance Routine did on Monday.
__________________
~Alan | Anime | Books | TV | Twitter



I award you no points, and may God have mercy on your soul.
The Pants Party is offline   Reply With Quote
Old 10-29-2008, 08:41 PM   #12
pinata242
 
Join Date: Jul 2007
Posts: 215

pinata242's Gamercard
This one seems to be specific to XBLA Ms. Pac-Man for me:

Quote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 184 and userID = 22117' at line 3
Other games on my list work and I can safely save Ms. Pac-Man with 0 achievements, but 1..12 result in that error message.

I have removed the game from my list and re-added it but, as expected, the SQL generated didn't magically fix itself
pinata242 is offline   Reply With Quote
Old 10-29-2008, 11:47 PM   #13
jukkakhan
 
jukkakhan's Avatar
 
Join Date: Jan 2008
Posts: 833

JukkaKhan's Gamercard

Awards Showcase Arcade Crazy - Bronze   Over Achiever - Bronze   Submit - Gold   Road Map - Silver
Total Awards: 4 (more» ...)
I get the same error as pinata242 but for Guitar Hero 2 and Guitar Hero 3.

Quote:
Originally Posted by Guitar Hero II
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 195 and userID = 50773' at line 3
Quote:
Originally Posted by Guitar Hero III
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 393 and userID = 50773' at line 3
Update: Both games seem to be working now for me.
__________________


Last edited by jukkakhan; 10-30-2008 at 04:37 PM.
jukkakhan is offline   Reply With Quote
Old 10-30-2008, 12:10 PM   #14
Miniman
 
Join Date: Jan 2008
Posts: 102
Getting that error aswell but for Avatar:The Burning Earth.

Quote:
Originally Posted by Avatar:The Burning Earth
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 392 and userID = 54725' at line 3
Miniman is offline   Reply With Quote
Old 10-30-2008, 07:21 PM   #15
Ghinn
 
Join Date: Jan 2008
Posts: 78

GhinnReborn's Gamercard
Have the same problem with army of two:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 197 and userID = 50080' at line 3

Also have the problem where sometimes games will load in a blink, other times it takes upwards of 10 minutes, sometimes at the same time (i.e. one game list will load instantly, one will take for ever)

Other than that, couldn't live without the site. Keep up the good work!
__________________
Ghinn is offline   Reply With Quote
Old 10-30-2008, 09:38 PM   #16
crowdsurfer1987
 
Join Date: Apr 2007
Posts: 10

crowdsurfer1987's Gamercard
i am having a problem with scene it lca it keeps changing the achievements i have clicked everytime i do it, some times i have 250g sometimes i have 530 when really i have 800 and something lol, any ideas? i tried deleting it all and starting again twice it doesnt work
crowdsurfer1987 is offline   Reply With Quote
Old 10-31-2008, 08:38 AM   #17
Klister NL
 
Klister NL's Avatar
 
Join Date: Jan 2008
Location: Arnhem, Netherlands
Posts: 192

Klister NL's Gamercard
I'm getting the same error as the above posters, but for me it's Turning Point: Fall of Liberty

Quote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 374 and userID = 50991' at line 3
__________________


Klister NL is offline   Reply With Quote
Old 10-31-2008, 08:53 AM   #18
Interface23
 
Join Date: Oct 2007
Posts: 92
Send a message via AIM to Interface23

Interface23's Gamercard

Awards Showcase Submit - Bronze
Total Awards: 1 (more» ...)
Infinite Undiscovery


Quote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 450 and userID = 31975' at line 3
Interface23 is offline   Reply With Quote
Old 10-31-2008, 09:14 AM   #19
android_odnetnin
 
android_odnetnin's Avatar
 
Join Date: Feb 2008
Location: Kenosha, WI
Posts: 25
Send a message via AIM to android_odnetnin Send a message via Yahoo to android_odnetnin

AndroidOdnetnin's Gamercard
I'm getting the same error as the above for Ms. Pac-Man when I tried to update my achievements.

Quote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 184 and userID = 57734' at line 3
__________________
----Skip





android_odnetnin is offline   Reply With Quote
Old 10-31-2008, 07:30 PM   #20
GeneralIzor
 
GeneralIzor's Avatar
 
Join Date: Jan 2008
Location: Sweden
Posts: 41

Generalizor's Gamercard
My Gamerscore cant add in the Ninja Gaiden 2 and Guitar Hero 3 the text :

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 444 and userID = 53776' at line 3"
GeneralIzor is offline   Reply With Quote
Old 10-31-2008, 08:16 PM   #21
pinata242
 
Join Date: Jul 2007
Posts: 215

pinata242's Gamercard
Anybody looking into this issue? Seems fairly simple to get someone to look at why the sql being generated isn't working.
pinata242 is offline   Reply With Quote
Old 10-31-2008, 10:22 PM   #22
Elitism
 
Elitism's Avatar
 
Join Date: Jan 2008
Location: Clarksville, TN
Posts: 191

Elitism's Gamercard
Guitar hero III

Guitar hero III will not save my checked off achievements...here is the error it gives...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE gameID = 393 and userID = 55266' at line 3


Thanks...
__________________


ATTN: I'm an ADULT gamer with MIC and I am only looking for serious boosting partners. Thanks!
Elitism is offline   Reply With Quote
Old 11-01-2008, 02:34 AM   #23
TheCanWithin
 
TheCanWithin's Avatar
 
Join Date: Jul 2007
Location: Sydney, Australia
Posts: 221

Aazarah's Gamercard

Awards Showcase Submit - Silver
Total Awards: 1 (more» ...)
This sort of relates to number 3.

In "Marble Blast Ultra", when you check one of the newly released achievements and then hit save (For example "Blue Gem Hunt"), they uncheck themselves and the total score remains the same as it was before. (Basically, the list isn't working).
__________________
TheCanWithin is offline   Reply With Quote
Old 11-01-2008, 03:11 AM   #24
fantom88
 
fantom88's Avatar
 
Join Date: Jun 2008
Location: Alberta, Canada
Posts: 39

pwnseidon's Gamercard

Awards Showcase Submit - Bronze   Donator - Level 1
Total Awards: 2 (more» ...)
Quote:
Originally Posted by TheCanWithin View Post
This sort of relates to number 3.

In "Marble Blast Ultra", when you check one of the newly released achievements and then hit save (For example "Blue Gem Hunt"), they uncheck themselves and the total score remains the same as it was before. (Basically, the list isn't working).
Hey, Pants Party laid it out a little bit above here but I created a thread in the Marble Blast Ultra forum outlining the solution to the problem. (http://www.xbox360achievements.org/f...d.php?t=101638)

Basically, you must delete the tracking data for that game. (simply disabling it and then re-enabling it will not work)

Edit in response to reply: No problem!

Last edited by fantom88; 11-01-2008 at 03:14 AM.
fantom88 is offline   Reply With Quote
Old 11-01-2008, 03:14 AM   #25
TheCanWithin
 
TheCanWithin's Avatar
 
Join Date: Jul 2007
Location: Sydney, Australia
Posts: 221

Aazarah's Gamercard

Awards Showcase Submit - Silver
Total Awards: 1 (more» ...)
Quote:
Originally Posted by fantom88 View Post
Hey, Pants Party laid it out a little bit above here but I created a thread in the Marble Blast Ultra forum outlining the solution to the problem. (http://www.xbox360achievements.org/f...d.php?t=101638)
Ooops, well, thanks for that
__________________
TheCanWithin is offline   Reply With Quote
Old 11-02-2008, 11:07 AM   #26
venom1983Pro
 
Join Date: Dec 2007
Posts: 27

venom1983PRO's Gamercard
On my list of game sit showns all the achievments i have got but when i then click on the link to take me to any of the games there are no achievments ticked and says I have 0 gamer score and 0 achievments, go back to the list and it still shows all the games and the bars are filled in and says how much i have done!
__________________
Venom1983PRO the man behind the legend
Founder of 360ukGamers




venom1983Pro is offline   Reply With Quote
Old 11-02-2008, 11:09 AM   #27
venom1983Pro
 
Join Date: Dec 2007
Posts: 27

venom1983PRO's Gamercard
Sorry scratch that just been back on and is now working fine!

Its just my Guitar Hero 2 and 3 that arent working
__________________
Venom1983PRO the man behind the legend
Founder of 360ukGamers




venom1983Pro is offline   Reply With Quote
Old 11-02-2008, 02:50 PM   #28
marsmj
 
Join Date: Mar 2008
Location: Arkansas
Posts: 140

marsmj's Gamercard
Fix't by deleting and then re-getting it. Sorry, shoulda tried that before posting.
__________________



Current Retail:
Marvel: Ultimate Alliance 575/1250
The Simpsons 75/1000
Halo 3 60/1000
Rock Band 50/1000
Assassin's Creed 0/1000

Current Arcade:
Aegis Wing 65/200

Completed Games:


Last edited by marsmj; 11-02-2008 at 02:54 PM.
marsmj is offline   Reply With Quote
Old 11-02-2008, 03:58 PM   #29
Sway Leggs
 
Sway Leggs's Avatar
 
Join Date: Jan 2008
Location: Florida
Posts: 46

Sway Leggs's Gamercard
Im not sure if this is the right place for this, but id like to know why
madden 09 is not on the list?
__________________








Sway Leggs is offline   Reply With Quote
Old 11-03-2008, 04:12 AM   #30
lu3mm3l
 
Join Date: Dec 2007
Location: Near Frankfurt/Germany
Posts: 119

lu3mm3l's Gamercard
Wrote this in another thread before: Saving Rez HD achievements still doesnt work.
__________________
lu3mm3l is offline   Reply With Quote
Reply

Bookmarks

Tags
assistance, fear files., glitch?, my acheivements, website

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 05:39 PM.