![]() |
Quote:
|
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 10 STR: -> SQL: $db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ") SQL-query: $db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ") MySQL said: Documentation #1064 - You have an error in your SQL syntax near '$db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD rating INT( 10 ) UNSI' at line 1 |
it seems to work but i seem to have some template screw ups http://forums.drift-forums.com/userpage.php?do=list
yeah now that i look at it theres no user cp link, and the link in their profile causes a db error likey because of the above post |
Quote:
Amy |
Quote:
btw, its Rob |
nvm found it, i dont have one
|
ok so if i was to run this queries in phpmyadmin what would i put?
|
The WOL is messed up, I'm shown as "Unknown Location
/vb/userpage.php?do=main&userid=1"... |
I updated and now there are no links in usercpmenu. Tested with a new user, and even the create personal page is gone. The USERCP_SHELL update:
<if condition="$show['createuserpagelink']"> <tr> <td class="$navclass[signature]" nowrap="nowrap"><a class="smallfont" href="userpage.php?$session[sessionurl]do=create">Create Your Userpage</a></td> </tr> </if> <if condition="$show['edituserpagelink']"> <tr> <td class="$navclass[signature]" nowrap="nowrap"><a class="smallfont" href="userpage.php?$session[sessionurl]do=edit">Edit Your Userpage</a></td> </tr> </if> is not working. I have gone through the steps and nothing brings new links in the usercp menu. I can access my personal page via url, and also get a listing via url, have added a link in the navbar using : <if condition="$show['member']"> <td class="vbmenu_control"><a href="userpage.php?$session[sessionurl]do=list">$vbphrase[users_blog]</a></td> </if> , but I dont want both edit and create personal page in my navbar. How do I add the links to usercp? |
cecdah, did you install the plugin? That sets it up so the links will show in the usercp.
Regarding the who's online I may need to add more locations in the plugin. I'll look into it, Sovereign. |
It was the userpage-plugins.xml right? Not the userpage.xml located in the admincpfolder?
|
Right. and if you look in your plugin manager, you should see a plugin for Userpage usercp link
|
no help for me? :(
|
Quote:
Code:
$db->query_write("ALTER TABLE userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL "); |
Quote:
|
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 4 STR: -> SQL: $db->query_write("ALTER TABLE userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ") SQL-query: $db->query_write("ALTER TABLE userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ") MySQL said: Documentation #1064 - You have an error in your SQL syntax near '$db->query_write("ALTER TABLE userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0'' at line 1 im using phpmyadmin btw |
Code:
ALTER TABLE userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL; |
thanks again
|
that fixed it works perfectly, excpet i see no link in the user cp
|
Also I have a few ideas for your next release.
I see we both use coppermine. I was thinking of having a navigation box like you have on your forum, but only appears on the user's page. They can put whatever links they want in there, but also it has a link to their coppermine image gallery. Also the ability to create more than one page. Like they can have an option to "add new page" or something (which also adds to the navigation box). Just a few ideas. Heres a ++++ty photoshop of my idea http://uploads.drift-forums.com/files/cappyps.jpg |
Quote:
Thanks in advanced! Chanhlinh |
Quote:
One more thing: Users should be able to delete / alter shouts in their shoutbox, so that there is no need to contact the mods/admins. Andreas |
I have the pluginlink, but still no link in usercp.
I might go around this by adding a link in the navbar named "Blog", and place submenus with "Users with blog" + Edit blog + create blog |
Quote:
http://yourforum.com/forum/admincp/i...buildbitfields :) |
Quote:
Go to admincp, languages and phrases, phraseadministration I think (have another translation). Check page by page that every phrase has a translation in your default language. This worked for me when I couldnt see the alternatives for permissions. |
Amykhar: I finally got it right, deleted the links in pluginpage, and imported the xmlfile fresh!
Everything is working like a charm. http://72.34.32.133/~hemmelig/forum/...s/lykkelig.gif |
Thank you very much. It's done :)
|
Personalpagetip for inserting images:
I find no IMG tag in the editbox, but basic html works great. Like this: <img src="http://www.swapmeetdave.com/Humor/Blonde.jpg"> :) |
The img tag is there for me. :confused: Which style of editor are you using in your account? I am using the WYSIWYG.
|
I am using the WYSIWYG, but no IMG tag.
|
:ermm:
|
OK. Let me look at the parameters passed into the editor again. BRB.
|
Dumb question, does the img tag show up for you on your posting and PM templates? From what I've read in the code, it checks to see if you have img bbcode enabled and then shows the button.
Amy |
this is a very sweet mod and open to expansion too :)
|
Quote:
|
Quote:
However, I will check some more before blaiming it on the hack. :) |
Is there anywhere that you don't allow images? signatures, private messages, etc?
|
yo amy did you read my ideas? I'm interested to know what you think.
|
are you supposed to delete the old plugin before you run the new one?
|
Quote:
|
All times are GMT. The time now is 03:32 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|