Forums / Cotonti / Support / SQL Error!

Error::

---

Design Studio
2009-04-04 12:47
Fatal error : SQL error : 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 aff_active='1' ORDER BY RAND() LIMIT 0,1' at line 1

This happened after i installed the affiliates plugin from seditio.
How do i fix it?

Well i did read it but i did not understand:



How do I install XsAFF?
Updated: Wednesday 09th of May 2007 08:16 PM Asked By: Xiode

Upload
__________________________________________________________
FOLDERSwww/plugins/xsaff/ => plugins/xsaff/
www/plugins/xsaff/lang/ => plugins/xsaff/lang/
www/plugins/xsaff/affimg/ => plugins/xsaff/affimg/
www/plugins/xsaff/inc/ => plugins/xsaff/inc/
www/plugins/xsaff/inc/fonts => plugins/xsaff/inc/fonts
___________________________________________________________
FILES
___________________________________________________________
www/plugins/xsaff/xsaff.php => plugins/xsaff/xsaff.php
www/plugins/xsaff/xsaff.setup.php => plugins/xsaff/xsaff.setup.php
www/plugins/xsaff/xsaff.tpl => plugins/xsaff/xsaff.tpl
www/plugins/xsaff/xsaff.copy.php => plugins/xsaff/xsaff.copy.php
www/plugins/xsaff/xsaff.header.php => plugins/xsaff/xsaff.header.php
www/plugins/xsaff/xsaff.admin.php => plugins/xsaff/xsaff.admin.php
www/plugins/xsaff/lang/xsmm.en.lang.php => plugins/xsaff/lang/xsaff.en.lang.php
www/plugins/xsaff/inc/xsaff.funtions.php => plugins/xsaff/inc/xsaff.funtions.php
www/plugins/xsaff/inc/xsaff.tb.php => plugins/xsaff/inc/xsaff.tb.php
www/plugins/xsaff/inc/php-captcha.inc.php => plugins/xsaff/inc/php-captcha.inc.php
www/plugins/xsaff/inc/captcha.php => plugins/xsaff/inc/captcha.php
www/plugins/xsaff/inc/fonts/Dekadens.ttf => plugins/xsaff/inc/fonts/Dekadens.ttf
www/plugins/xsaff/inc/fonts/SwatchIt.ttf => plugins/xsaff/inc/fonts/SwatchIt.ttf
www/plugins/xsaff/inc/fonts/VeraMoBd.ttf => plugins/xsaff/inc/fonts/VeraMoBd.ttf
__________________________________________________________________________________________


CHMOD
CHMOD the plugins/xsaff/affimg/ folder to 777

MYSQL
Open up your favorite mysql admin, and run this
____________________________________________________

SQLCREATE TABLE `sed_xsaff_aff` (
`aff_id` mediumint(8) unsigned NOT NULL auto_increment,
`aff_name` varchar(255) NOT NULL default '',
`aff_uname` varchar(255) NOT NULL default '',
`aff_uid` int(11) NOT NULL default '0',
`aff_desc` text NOT NULL,
`aff_img` varchar(255) NOT NULL default '',
`aff_url` varchar(255) NOT NULL default '',
`aff_hits` mediumint(8) unsigned default '0',
`aff_broke` int(11) NOT NULL default '0',
`aff_active` int(11) NOT NULL default '0',
PRIMARY KEY (`aff_id`)
) ENGINE=MyISAM;

CREATE TABLE `sed_xsaff_terms` (
`terms_text` text NOT NULL
) TYPE=MyISAM;



INSTALL
Go into the administration panel, then tab Plugins, click XsAffiliates, and at bottom of the plugin properties, select Install all. Once you have finished installing it get to configuring it.

CORE HACKS

OPEN www/datas/config.php


FIND ?>


BEFORE ADD$db_xsaff_aff = 'sed_xsaff_aff';
$db_xsaff_terms = 'sed_xsaff_terms';



CORE CONFIGURATION
Navigate to http://www.yourdomain.com/admin.php?m=config&n=edit&o=plug&p=xsaff. Here you will see 3 choices.
- How many should be listed before pagination occurs? This is a drop down where you can select the amount of affiliates to show per page.
- Pagination method (sedplus only if installed) If you have sedplus installed you can use it's pagination.
- Make them agree to your terms? This is where you can turn this feature on/off. If you don't wantto use it then just switch it to off.

SKIN INTEGRATION
If you want to integrate the xsaff.tpl into your own skin. All you have to do is rename the file to xsaff.standalone.tpl and place it in your skin's folder.

SKIN MODIFICATION
If you want to display the random affiliate then all you have to do is add {XSAFF} to your header.tpl where ever you want it to be displayed. {XSAFF} only outputs a div with the image centered. You will have to build the box around it. If you want it to display on the index or such just modify the hook and tag accordingly.

What is the part you don't understand?

# gamer24.7 :
Upload
is like any other plugin
FILES
just a line up of all files in the plugin
CHMOD
CHMOD the plugins/xsaff/affimg/ folder to 777
Change the permissions of the directory "plugins/xsaff/affimg/" to 777
MYSQL
Open up your favorite mysql admin, and run this
Run these in your sql-program

INSTALL
= like any other plugin

CORE HACKS
Add in /datas/config.php
just before "?>"
$db_xsaff_aff = 'sed_xsaff_aff';
$db_xsaff_terms = 'sed_xsaff_terms';

CORE CONFIGURATION
Navigate to http://www.yourdomain.com/admin.php?m=config&n=edit&o=plug&p=xsaff. Here you will see 3 choices.
= config of the plugin (like any other plugin)

SKIN INTEGRATION
This is what you need to do if you want a custom tpl in your skindirectory

SKIN MODIFICATION
= explains itself

# gamer24.7 : I did that and now i get this:

Design Studio
2009-04-04 13:17
Fatal error : SQL error : Table 'a3079628_gamer.sed_xsaff_aff' doesn't exist

Oh dear god. You do remember the last topic you made?

Edit: In case you dont remember: http://www.cotonti.com/forums.php?m=posts&q=2546&n=last#bottom

Fatal error : SQL error : Table 'a3079628_gamer.sed_xsaff_aff' doesn't exist

I hate to quote myself but I already replied in the previous topic:

# Lombi : It's all in the video documetation, please take your time and watch it all, here is the link to the specific video tutorial covering importing of sql files.

Put this in a text editor, save as sql and import it:

SQLCREATE TABLE `sed_xsaff_aff` (
`aff_id` mediumint(8) unsigned NOT NULL auto_increment,
`aff_name` varchar(255) NOT NULL default '',
`aff_uname` varchar(255) NOT NULL default '',
`aff_uid` int(11) NOT NULL default '0',
`aff_desc` text NOT NULL,
`aff_img` varchar(255) NOT NULL default '',
`aff_url` varchar(255) NOT NULL default '',
`aff_hits` mediumint(8) unsigned default '0',
`aff_broke` int(11) NOT NULL default '0',
`aff_active` int(11) NOT NULL default '0',
PRIMARY KEY (`aff_id`)
) ENGINE=MyISAM;

CREATE TABLE `sed_xsaff_terms` (
`terms_text` text NOT NULL
) TYPE=MyISAM;

A faster way is to choose "SQL" in the tabs above in phpmyadmin (instead of import), paste that in and run it. http://community.mybboard.net/attachment.php?aid=1558

More documentation on that: http://www.google.com/search?hl=sl&client=opera&rls=en&hs=L9r&num=100&q=how+to+run+sql+queries+in+phpmyadmin&btnG=Iskanje&lr=

First result: http://community.mybboard.net/showthread.php?tid=4720

Please remember to read the documentation next time you install a plugin.