| Author |
Message |
MACscr
Joined: Jan 11, 2005
Posts: 128
Status: Offline
|
 Posted:
Jan 12, 2005 - 01:17 PM |
 
|
Im getting this at the top of my page.
| Quote: |
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 ' FROM WHE
|
I have edited the templates to display the profile, but im pretty sure i got the same error then too. Everything else appears to display correctly even with error. Let me check what my Mysql version is, I know its pretty up to date. |
Last edited by MACscr on Jan 12, 2005 - 01:23 PM; edited 1 time in total |
|
  
|
|
Chestnut
Site Admin
Joined: Oct 08, 2003
Posts: 1065
Location: Paris - France
|
| Posted:
Jan 12, 2005 - 03:06 PM |
|
Remove all plugins that you do not use... pncuserpoints for example. |
_________________
Chestnut ! 
Administrator
PNConcept.com |
|
  |
|
MACscr
Joined: Jan 11, 2005
Posts: 128
Status: Offline
|
| Posted:
Jan 12, 2005 - 04:51 PM |
|
I removed all the plugins except the pnphpbb one, which im using. Got rid of error. Thanks. |
|
|
|
|
|
dank
Joined: May 18, 2005
Posts: 1
Status: Offline
|
| Posted:
May 18, 2005 - 12:53 AM |
|
I'm having the same problem and removal of the plugins results in a blank page when calling advProfile |
|
|
|
|
|
Chestnut
Site Admin
Joined: Oct 08, 2003
Posts: 1065
Location: Paris - France
|
| Posted:
May 18, 2005 - 02:11 AM |
|
In advProfile 2.0, you can remove only the plugin call in the templates (main, activity, etc)... Removing the plugin files without removing the call in the templates will result in various smarty errors...
Removing the plugin call without removing the files is ok. |
_________________
Chestnut !
Administrator
PNConcept.com
Last edited by Chestnut on May 18, 2005 - 02:13 AM; edited 1 time in total |
|
|
|
|
MACscr
Joined: Jan 11, 2005
Posts: 128
Status: Offline
|
| Posted:
May 28, 2005 - 10:55 PM |
|
| Chestnut wrote: | In advProfile 2.0, you can remove only the plugin call in the templates (main, activity, etc)... Removing the plugin files without removing the call in the templates will result in various smarty errors...
Removing the plugin call without removing the files is ok. |
Why would you want to do it that way? Its not much of a plugin if its required. |
|
|
|
|
|
Chestnut
Site Admin
Joined: Oct 08, 2003
Posts: 1065
Location: Paris - France
|
| Posted:
May 28, 2005 - 11:08 PM |
|
Not sure I grasp what you mean...
In advProfile 1.x, the module was checking the content of the pnplugins folder, including all files and executing all functions.
Wich is far from a good thing.
In advProfile 2.0, using the smarty call, the file is included only if called in the template. If the plugin tag is not in the template, the plugin file is useless.
There is nothing required. (Except that if you put the call in your template, you have to have the file of course.)
 |
_________________
Chestnut !
Administrator
PNConcept.com |
|
|
|
|
MACscr
Joined: Jan 11, 2005
Posts: 128
Status: Offline
|
| Posted:
May 29, 2005 - 12:08 AM |
|
lol, my bad, read that wrong. Thought the files had to be in the directory no matter what. |
|
|
|
|
|
hardtrancer
Joined: Jun 05, 2004
Posts: 7
Status: Offline
|
| Posted:
Jun 04, 2005 - 05:46 PM |
|
Removing 2 plugins doesn't work for me.
I still have this sql error message, also the german language isn't working even with a deu directory created 
pn0.760-RC4 and advProfiles2.0 |
|
|
|
|
|
Chestnut
Site Admin
Joined: Oct 08, 2003
Posts: 1065
Location: Paris - France
|
| Posted:
Jun 04, 2005 - 06:14 PM |
|
You have to remove the plugin call in the templates.
Example :
| Code: |
<!--[pncpaypal uid=$uid]--> <------ remove this
|
Also, go to your pnRender administration and click on the "delete compiled templates" and "delete cached..." to make sure that what you are seeing is not an old page. You can also set "force template compilation" to on while you are trying to make it work right.
I don't have Deu files so can't say for the moment but if you rename the eng to deu... it should work. After that, replace one by one the eng files (in your deu folder). Maybe there was an incomplete file... |
_________________
Chestnut !
Administrator
PNConcept.com |
|
|
|
|
hardtrancer
Joined: Jun 05, 2004
Posts: 7
Status: Offline
|
| Posted:
Jun 06, 2005 - 12:46 PM |
|
I did remove all this, also those with uname in it - but the error ist still there |
|
|
|
|
|
Chestnut
Site Admin
Joined: Oct 08, 2003
Posts: 1065
Location: Paris - France
|
| Posted:
Jun 06, 2005 - 01:22 PM |
|
|
|
|
|
Vinyard
Joined: Sep 09, 2005
Posts: 2
Status: Offline
|
| Posted:
Sep 09, 2005 - 09:09 AM |
|
I had this problem and I had to fumble around with it before I got it. SO here is a dumbed down way of how to get rid of that error
go into the
modules/advprofile/pntemplates/default
and edit
advProfile_user_main.tpl & advProfile_user_all.tpl
delete these lines
<!--[pncuserpoints uid=$uid assign="pncuserpoints"]-->
<!--[if $pncuserpoints != false]-->
<tr>
<td class="title"><!--[pnml name="_USERPOINTSTITLE"]--></td>
<td><!--[$pncuserpoints|pnvarprepfordisplay]--></td>
</tr>
<!--[/if]-->
and these ones
<!--[pncpaypal uname=$USERNAME_VALUE assign="pncpaypal"]-->
<!--[if $pncpaypal != false]-->
<tr>
<td class="title"><!--[pnml name="_PNCPPCONTRIBUTIONS"]--></td> <td><!--[$pncpaypal.amount|pnvarprepfordisplay]--> (<!--[$pncpaypal.nbipn|pnvarprepfordisplay]-->)</td>
</tr>
<!--[/if]-->
THis worked for me. |
|
|
|
|
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
