Frequently Asked Questions

Search

Main Menu

Home
What is Majicko?
Majicko Blogs
Related Links
Podcasts
Documents
Photos
Polls

Calendar

September '10
S	M	T	W	T	F	S
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30

Site Styles

Latest News

19 December 2008
6 March 2008
4 October 2007

Majicko.com

FAQS

Frequently Asked Questions

What is a Code 103 Error?

This error occurs when Majicko's query system tries to process a fieldname that has already been set elsewhere on the page.

Majicko uses a very simple and powerful MySQL query system that makes executing queries quick and easy. Unfortunately, there is one major drawback in using this system. If you query for two identicle fieldnames on the same page, you will encounter the Code 103 error.

Let's take these two queries in example:
$sql="SELECT userid FROM maj_user";
$sql="SELECT userid FROM maj_profile";

These two queries both have a field called "userid." Therefore, both of these queries will execute and produce an array called "$userid[x]." After the first query executes, the array has now been established on the page. If you do not unset this array before the execution of the 2nd query, you will encounter the Code 103 error.

There are two ways you can handle this error. Firstly, you can adjust your second query to produce an array with a different name like so:

$sql="SELECT userid AS profile_userid FROM maj_profile";

This version of the exact same query will produce an array called "$profile_userid" instead of just "$userid" again. This way, the two queries won't interfere with each other and we'll still have both sets of data available.

The second way to deal with this error is less recommended. You can go to your config file and set $varreset to true. This will allow the query system to detect when an array has already been set. It will then unset the old array in order to make room for the new one. This may resolve the error, but may also cause some scripts elsewhere in Majicko to malfunction.

If you encountered this error after editing an existing file in Majicko, you should restore the file in order to correct this error. If you encountered this error in creating or editing a custom web page that was not originally part of your copy of Majicko, then we cannot assist in troubleshooting this error.