SQL syntax error

PatrickStar4491 · 02-06-2007, 04:04 PM

It's still only half-fixed. It looks like there's a deeper issue than I thought. I'll try to keep working with Lee about it.

PatrickStar4491 · 02-09-2007, 02:19 PM

I love it when things work.

Lee gave me the two files which needed modifications, and everything seems to be in working order.

Gustin, if you have an apostrophe problem in the other admin area, let me know which file it is.

**Gustin** · 02-09-2007, 11:38 PM

christianguitar.org/cgradmin/submit/modbsong.php Needs to be updated. Otherwise I think I'm fine.

Thanks sooooooo much Patrick. This will make life a lot easeir for all of us.

PatrickStar4491 · 02-10-2007, 09:11 AM

Does /cgradmin/submit/modcsong.php also need it?

**Gustin** · 02-10-2007, 09:23 AM

modcsong.php is the verification window (right after you modify the song and hit submit), so I imagine so.

PatrickStar4491 · 02-10-2007, 09:44 AM

Ah, I was wondering if that one was for bass tabs while the other one was for guitar tabs. I'll talk to Lee about that.

**Gustin** · 02-10-2007, 09:48 AM

Quote:

Originally Posted by PatrickStar4491

Ah, I was wondering if that one was for guitar tabs while the other one was for bass tabs. I'll talk to Lee about that.

I'm pretty sure that modbsongs.php mods all the tabs whether guitar or bass. I'll double check though.

Edit: That's correct. modbsong.php has the field for modifying the song, and modcsong.php covers the verification afterwards.

PatrickStar4491 · 02-10-2007, 09:53 AM

The one that needs editing is the one that contains the query to update the database. Is modcsong.php the one that tells you your tab has been updated?

**Gustin** · 02-10-2007, 10:01 AM

Quote:

Originally Posted by PatrickStar4491

The one that needs editing is the one that contains the query to update the database. Is modcsong.php the one that tells you your tab has been updated?

It is. Modb has the input fields, Modc updates the number of tabs and such.