<?xml version='1.0' encoding='UTF-8'?>
<rss version='2.0'>
	<channel>
		<title>cotonti.com : SQL Error!</title>
		<link>https://www.cotonti.com</link>
		<description>Neueste Themenbeiträge</description>
		<generator>Cotonti</generator>
		<language>en</language>
		<pubDate>Sun, 12 Apr 2026 06:12:59 -0000</pubDate>

		<item>
			<title>Lombi</title>
			<description><![CDATA[Please remember to read the documentation next time you install a plugin.]]></description>
			<pubDate>So, 05 Apr 2009 04:44:29 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11076]]></link>
		</item>
		<item>
			<title>gamer24.7</title>
			<description><![CDATA[YES!<br />
it's done.<br />
Thanks Lombi, trustmaster and pieater for helping!]]></description>
			<pubDate>So, 05 Apr 2009 04:43:25 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11074]]></link>
		</item>
		<item>
			<title>Lombi</title>
			<description><![CDATA[Put this in a text editor, save as sql and import it:<br />
<br />
<pre class="code">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;</pre>
<br />
A faster way is to choose &quot;SQL&quot; in the tabs above in phpmyadmin (instead of import), paste that in and run it. <a href="http://community.mybboard.net/attachment.php?aid=1558" rel="nofollow">http://community.mybboard.net/attachment.php?aid=1558</a><br />
<br />
More documentation on that: <a href="http://www.google.com/search?hl=sl&amp;client=opera&amp;rls=en&amp;hs=L9r&amp;num=100&amp;q=how+to+run+sql+queries+in+phpmyadmin&amp;btnG=Iskanje&amp;lr=" rel="nofollow">http://www.google.com/search?hl=sl&amp;client=opera&amp;rls=en&amp;hs=L9r&amp;num=100&amp;q=how+to+run+sql+queries+in+phpmyadmin&amp;btnG=Iskanje&amp;lr=</a><br />
<br />
First result: <a href="http://community.mybboard.net/showthread.php?tid=4720" rel="nofollow">http://community.mybboard.net/showthread.php?tid=4720</a>]]></description>
			<pubDate>So, 05 Apr 2009 04:27:56 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11072]]></link>
		</item>
		<item>
			<title>gamer24.7</title>
			<description><![CDATA[They hav not given any sql file to run... <img class="aux smiley" src="https://www.cotonti.com/./images/smilies/confused.gif" alt=":-/" />]]></description>
			<pubDate>So, 05 Apr 2009 04:25:56 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11070]]></link>
		</item>
		<item>
			<title>Lombi</title>
			<description><![CDATA[Fatal error : SQL error : <strong><span style="color:#CC0000">Table</span></strong> 'a3079628_gamer.sed_xsaff_aff' <span style="color:#CC0000"><strong>doesn't exist</strong></span><br />
<br />
I hate to quote myself but I already replied in the previous topic:<br />
<br />
<blockquote><a href="https://www.cotonti.com/forums.php?m=posts&amp;p=11045#11045">#</a> <strong>Lombi :</strong>
<a href="http://www.cotonti.com/docs/">It's all in the video documetation</a>, please take your time and watch it all, <a href="http://www.cotonti.com/docs/en/videos/import_sql_phpmyadmin">here is the link to the specific video tutorial covering importing of sql files</a>.<br />
</blockquote>]]></description>
			<pubDate>So, 05 Apr 2009 04:24:55 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11069]]></link>
		</item>
		<item>
			<title>gamer24.7</title>
			<description><![CDATA[I'm stuck on this bit:<br />
MYSQL<br />
Open up your favorite mysql admin, and run this<br />
Run these in your sql-program]]></description>
			<pubDate>So, 05 Apr 2009 04:23:52 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11068]]></link>
		</item>
		<item>
			<title>Lombi</title>
			<description><![CDATA[<blockquote><a href="https://www.cotonti.com/forums.php?m=posts&amp;p=11066#11066">#</a> <strong>gamer24.7 :</strong>
I did that and now i get this:<br />
<br />
<span style="color:#000000">Design Studio</span><br />
2009-04-04 13:17<br />
Fatal error : SQL error : Table 'a3079628_gamer.sed_xsaff_aff' doesn't exist<br />
</blockquote>
<br />
Oh dear god. You do remember the last topic you made?<br />
<br />
Edit: In case you dont remember: <a href="http://www.cotonti.com/forums.php?m=posts&amp;q=2546&amp;n=last#bottom">http://www.cotonti.com/forums.php?m=posts&amp;q=2546&amp;n=last#bottom</a>]]></description>
			<pubDate>So, 05 Apr 2009 04:23:03 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11067]]></link>
		</item>
		<item>
			<title>gamer24.7</title>
			<description><![CDATA[I did that and now i get this:<br />
<br />
<span style="color:#000000">Design Studio</span><br />
2009-04-04 13:17<br />
Fatal error : SQL error : Table 'a3079628_gamer.sed_xsaff_aff' doesn't exist]]></description>
			<pubDate>So, 05 Apr 2009 04:18:10 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11066]]></link>
		</item>
		<item>
			<title>pieter</title>
			<description><![CDATA[What is the part you don't understand?<br />
<blockquote><a href="https://www.cotonti.com/forums.php?m=posts&amp;p=11063#11063">#</a> <strong>gamer24.7 :</strong>
<br />
<strong>Upload</strong><br />
<span style="color:#EF2929">is like any other plugin </span><br />
<strong>FILES</strong><br />
<span style="color:#EF2929">just a line up of all files in the plugin</span><br />
<strong>CHMOD</strong><br />
CHMOD the plugins/xsaff/affimg/ folder to 777<br />
<span style="color:#EF2929">Change the permissions of the directory &quot;plugins/xsaff/affimg/&quot; to 777</span><br />
<strong>MYSQL</strong><br />
<span style="color:#EF2929">Open up your favorite mysql admin, and run this<br />
Run these in your sql-program</span><br />
<br />
<strong>INSTALL</strong><br />
<span style="color:#EF2929">= like any other plugin</span><br />
<br />
<strong>CORE HACKS</strong><br />
<span style="color:#EF2929">Add in /datas/config.php</span><br />
just before &quot;?&gt;&quot;<br />
<em>$db_xsaff_aff = 'sed_xsaff_aff';<br />
$db_xsaff_terms = 'sed_xsaff_terms';</em><br />
<br />
<strong>CORE CONFIGURATION</strong><br />
Navigate to <a href="http://www.yourdomain.com/admin.php?m=config&amp;n=edit&amp;o=plug&amp;p=xsaff." rel="nofollow">http://www.yourdomain.com/admin.php?m=config&amp;n=edit&amp;o=plug&amp;p=xsaff.</a> Here you will see 3 choices.<br />
<span style="color:#EF2929">= config of the plugin (like any other plugin)</span><br />
<br />
<strong>SKIN INTEGRATION</strong><br />
<span style="color:#EF2929">This is what you need to do if you want a custom tpl in your skindirectory</span><br />
<br />
<strong>SKIN MODIFICATION</strong><br />
<span style="color:#EF2929">= explains itself</span></blockquote>]]></description>
			<pubDate>So, 05 Apr 2009 04:12:21 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11065]]></link>
		</item>
		<item>
			<title>TwistedGA</title>
			<description><![CDATA[So you don't understand where BEFORE &quot;?&gt;&quot; is?<br />
<br />
?&gt; is the closing of the PHP file. Add this just above it.<br />
<br />
<div class="highlight"><pre class="php">
$db_xsaff_aff = 'sed_xsaff_aff';
$db_xsaff_terms = 'sed_xsaff_terms';
</pre></div>
<br />
<br />
Edit- Please edit your first post and change the topic title only, to something more like &quot;xsaff install problems&quot; of something similiar. Try to be more specific with Titles and Descriptions so people find what they need when searching. <img class="aux smiley" src="https://www.cotonti.com/./images/smilies/smile.gif" alt=":-)" />]]></description>
			<pubDate>So, 05 Apr 2009 04:08:46 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11064]]></link>
		</item>
		<item>
			<title>gamer24.7</title>
			<description><![CDATA[Well i did read it but i did not understand:<br />
<br />
<br />
<br />
How do I install XsAFF?<br />
Updated: Wednesday 09th of May 2007 08:16 PM Asked By: Xiode<br />
<br />
Upload<br />
__________________________________________________________<br />
    FOLDERSwww/plugins/xsaff/ =&gt; plugins/xsaff/<br />
    www/plugins/xsaff/lang/ =&gt; plugins/xsaff/lang/<br />
    www/plugins/xsaff/affimg/ =&gt; plugins/xsaff/affimg/<br />
    www/plugins/xsaff/inc/ =&gt; plugins/xsaff/inc/<br />
    www/plugins/xsaff/inc/fonts =&gt; plugins/xsaff/inc/fonts<br />
___________________________________________________________<br />
 FILES<br />
___________________________________________________________   <br />
 www/plugins/xsaff/xsaff.php =&gt; plugins/xsaff/xsaff.php<br />
    www/plugins/xsaff/xsaff.setup.php =&gt; plugins/xsaff/xsaff.setup.php<br />
    www/plugins/xsaff/xsaff.tpl =&gt; plugins/xsaff/xsaff.tpl<br />
    www/plugins/xsaff/xsaff.copy.php =&gt; plugins/xsaff/xsaff.copy.php<br />
    www/plugins/xsaff/xsaff.header.php =&gt; plugins/xsaff/xsaff.header.php<br />
    www/plugins/xsaff/xsaff.admin.php =&gt; plugins/xsaff/xsaff.admin.php<br />
    www/plugins/xsaff/lang/xsmm.en.lang.php =&gt; plugins/xsaff/lang/xsaff.en.lang.php<br />
    www/plugins/xsaff/inc/xsaff.funtions.php =&gt; plugins/xsaff/inc/xsaff.funtions.php<br />
    www/plugins/xsaff/inc/xsaff.tb.php =&gt; plugins/xsaff/inc/xsaff.tb.php<br />
    www/plugins/xsaff/inc/php-captcha.inc.php =&gt; plugins/xsaff/inc/php-captcha.inc.php<br />
    www/plugins/xsaff/inc/captcha.php =&gt; plugins/xsaff/inc/captcha.php<br />
    www/plugins/xsaff/inc/fonts/Dekadens.ttf =&gt; plugins/xsaff/inc/fonts/Dekadens.ttf<br />
    www/plugins/xsaff/inc/fonts/SwatchIt.ttf =&gt; plugins/xsaff/inc/fonts/SwatchIt.ttf<br />
    www/plugins/xsaff/inc/fonts/VeraMoBd.ttf =&gt; plugins/xsaff/inc/fonts/VeraMoBd.ttf<br />
__________________________________________________________________________________________<br />
<br />
<br />
CHMOD<br />
CHMOD the plugins/xsaff/affimg/ folder to 777<br />
<br />
MYSQL<br />
Open up your favorite mysql admin, and run this<br />
____________________________________________________<br />
<br />
    SQLCREATE TABLE `sed_xsaff_aff` (<br />
    `aff_id` mediumint(8) unsigned NOT NULL auto_increment,<br />
    `aff_name` varchar(255) NOT NULL default '',<br />
    `aff_uname` varchar(255) NOT NULL default '',<br />
    `aff_uid` int(11) NOT NULL default '0',<br />
    `aff_desc` text NOT NULL,<br />
    `aff_img` varchar(255) NOT NULL default '',<br />
    `aff_url` varchar(255) NOT NULL default '',<br />
    `aff_hits` mediumint(8) unsigned default '0',<br />
    `aff_broke` int(11) NOT NULL default '0',<br />
    `aff_active` int(11) NOT NULL default '0',<br />
    PRIMARY KEY (`aff_id`)<br />
    ) ENGINE=MyISAM;<br />
<br />
    CREATE TABLE `sed_xsaff_terms` (<br />
    `terms_text` text NOT NULL<br />
    ) TYPE=MyISAM;<br />
<br />
<br />
<br />
INSTALL<br />
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.<br />
<br />
CORE HACKS<br />
<br />
    OPEN www/datas/config.php<br />
<br />
<br />
    FIND ?&gt;<br />
<br />
<br />
    BEFORE ADD$db_xsaff_aff = 'sed_xsaff_aff';<br />
    $db_xsaff_terms = 'sed_xsaff_terms';<br />
<br />
<br />
<br />
CORE CONFIGURATION<br />
Navigate to <a href="http://www.yourdomain.com/admin.php?m=config&amp;n=edit&amp;o=plug&amp;p=xsaff." rel="nofollow">http://www.yourdomain.com/admin.php?m=config&amp;n=edit&amp;o=plug&amp;p=xsaff.</a> Here you will see 3 choices.<br />
- 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.<br />
- Pagination method (sedplus only if installed) If you have sedplus installed you can use it's pagination.<br />
- 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.<br />
<br />
SKIN INTEGRATION<br />
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.<br />
<br />
SKIN MODIFICATION<br />
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.]]></description>
			<pubDate>So, 05 Apr 2009 04:03:50 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11063]]></link>
		</item>
		<item>
			<title>Lombi</title>
			<description><![CDATA[gamer24.7, this is yet another friendly reminder to <strong>read</strong> the <strong>installation documentation</strong> before jumping head first into the pond.<br />
<br />
Specifically, what does it say about editing your <strong>config.php</strong> and adding a new line in there?]]></description>
			<pubDate>So, 05 Apr 2009 03:56:24 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11062]]></link>
		</item>
		<item>
			<title>gamer24.7</title>
			<description><![CDATA[<blockquote><strong>Error::</strong><hr />Design Studio<br />
2009-04-04 12:47<br />
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</blockquote>
<br />
This happened after i installed the affiliates plugin from seditio.<br />
How do i fix it?]]></description>
			<pubDate>So, 05 Apr 2009 03:49:45 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/de/forums?m=posts&q=2551&d=0#post11060]]></link>
		</item>
	</channel>
</rss>