HTTP 500 Error with AutoTheme

Hangin' Around Joined: Feb 08, 2010 Posts: 27

I'm hoping this is an easy one, but I don't speak sql fluently yet, though I am trying hard to learn it.

I'm getting a 500 error when I try to select a theme for my website. It worked on the PHP Nuke 8.0 site that I had before I switched to Raven Nuke, but not so much now. Anyway, this is the debug line that I got from my troubleshooting.

Fatal error: Call to undefined function sql_query() in /home/*****/public_html/modules/AutoTheme/includes/php-nuke/atAPI.php on line 301

Posted: Tue Feb 09, 2010 11:33 am

Can you post the code on this line.

Posted: Tue Feb 09, 2010 1:54 pm

Crap. I'm going to have to get a copy of SQL management studio or something. I am about to go cross-eyed trying to count 301 lines. LOL! I'll post the line as soon as I get done installing the software.

Posted: Tue Feb 09, 2010 1:56 pm

Just download a copy of notepad++, it is free. Wink

Posted: Tue Feb 09, 2010 2:12 pm

I found a free DL of SQL Server 2008 Express. It's installing right now. Hopefully, this will work. I use SQL management Studio 2005 at my job, but the program I work on is very proprietary, so the structure is a lot different from PHP. I'm still trying to get used to this. My first website that I'm trying to put together solo, and I have no idea what I'm doing. LOL! I appreciate the help, guys! Really I do.

Posted: Tue Feb 09, 2010 3:04 pm

Line 301: $modtype = atGetModType();

Posted: Tue Feb 09, 2010 3:08 pm

OK, let me ask a totally noob-tastic question. If I restore a back up of my database to my blank SQL database on my computer, then I should be able to parse queries to find errors and fix them myself, right?

Posted: Tue Feb 09, 2010 3:12 pm

Yes, we always recommend running a test on a local system using XAMPP or similar.

Posted: Tue Feb 09, 2010 3:14 pm

So, why is AT asking for the mod type? Shouldn't it know which type of module already? Is it possible that I have a bad install of AT Lite or is it a simple conflict with the Raven Nuke architecture?

Posted: Tue Feb 09, 2010 3:17 pm

I haven't used Autotheme, but have you tried asking at the authors site?

Posted: Tue Feb 09, 2010 3:34 pm

I have, Jake. I haven't gotten a reply over there, compared with several from you. I was hoping Mars might see this thread and reply, since he is listed as a moderator for their site as well and created my theme. I've seen his replies to other questions about AT on this website. Call it hedging my bets, or whatever, I figured someone on either site might help and I could make sure the fix is posted at both sites to help someone else in my same situation.

EDIT: I copy/pasted, then modified my post from their website to here. I guess I just wanted to reassure you that I did try to go to the source first before asking the contributors here for help. I do appreciate the help. I'm finding a wealth of information stored here.

Posted: Tue Feb 09, 2010 3:48 pm

DRAT! I tried restoring the database in SMS 2008, and it says that the database is not formatted correctly. That's a matter for a different forum, I'm sure, but darn it.

Posted: Tue Feb 09, 2010 5:18 pm

how old is the version of autotheme you are using? Have you seen this?
http://www.spidean.com/name-News-article-sid-454.phtml

registered · Posted: Tue Feb 09, 2010 6:19 pm

Did you apply the AT Update for RavenNuke?
It looks like you don't have a proper upload and update done.
I just finally got around to installing 2.4 on my test site, installed AutoTheme, Installed the update and uploaded wow-lich01 and it works just fine?

Posted: Tue Feb 09, 2010 6:32 pm

Whoops! OK, now I feel like an idiot and I thought I was doing so well. No, I didn't run the update for Raven Nuke. I am using AT Lite v 0.87. That would explain a lot.