vb.org Archive
Page 11 of 52 « First 910 11 121321 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB3 Member Album 2.0 (https://vborg.vbsupport.ru/showthread.php?t=63733)

welo 04-25-2004 08:31 AM
Oh, and everything for your sorting selectors in album.php neglects prefixes too:

Code:
        $users = $DB_site->query("
                SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usergroupid,
                ".TABLE_PREFIX."user.usertitle, ".TABLE_PREFIX."usertextfield.signature, ".TABLE_PREFIX."usertextfield.sigdateline,
                ".TABLE_PREFIX."avatar.avatarpath, ".TABLE_PREFIX."user.avatarrevision, NOT ISNULL(".TABLE_PREFIX."customavatar.avatardata) AS hascustomavatar,
                ".TABLE_PREFIX."customavatar.dateline AS avatardateline
                FROM ".TABLE_PREFIX."user
                LEFT JOIN ".TABLE_PREFIX."usertextfield
                USING (userid)
                LEFT JOIN ".TABLE_PREFIX."avatar AS ".TABLE_PREFIX."avatar
                ON(".TABLE_PREFIX."avatar.avatarid = ".TABLE_PREFIX."user.avatarid)
                LEFT JOIN ".TABLE_PREFIX."customavatar AS ".TABLE_PREFIX."customavatar
                ON(".TABLE_PREFIX."customavatar.userid = ".TABLE_PREFIX."user.userid)
                WHERE ".TABLE_PREFIX."usertextfield.signature!=''$condition
                ORDER BY " . ($sort == 'dateline' ? 'sigdateline' : $sort) . " $order
                LIMIT " . ($minlimit-1) . ", $perpage
        ");

welo 04-25-2004 09:14 AM
Okay, hate to be a pest but this one I'm not tracking down. For some reason whenever I update my profile picture info from UCP, I get an error (a VB error - not SQL) saying:

Quote:
There has been an error in the upload. Please ensure that the file has been correctly selected and that the upload has taken place successfully.
I assume this indicates a glitch either with profile.php or includes/functions_upload.php, but I'm sure not seeing it. I'm not trying to upload a pic btw, just trying to add a comment to it.

subu1 04-25-2004 06:48 PM
verry nice Hack, i installed on vB3.0 Gold and i have an error by album.php

PHP Code:
Datenbankfehler in vBulletin 3.0.0:

Ungueltige SQL-Abfrage: 
        SELECT user.userid, dateline, 
        comment, user.username, user.usertitle, 
        user.joindate, user.usergroupid
        FROM customprofilepic 
        LEFT JOIN user USING (userid) 
        WHERE visible=1
         
        ORDER BY posts desc
        LIMIT 0, 18
    
mysql error: Unknown column 'comment' in 'field list'

mysql error number: 1054

Datum: 25.04.2004 21:46:36
Skript: [url]http://www.starlight-board.net/board/album.php[/url] 
sorry i can't find my error, all queries are run :rolleyes:

Pseudomizer 04-25-2004 06:58 PM
Quote:
Originally Posted by subu1
verry nice Hack, i installed on vB3.0 Gold and i have an error by album.php

PHP Code:
Datenbankfehler in vBulletin 3.0.0:

Ungueltige SQL-Abfrage: 
        SELECT user.userid, dateline, 
        comment, user.username, user.usertitle, 
        user.joindate, user.usergroupid
        FROM customprofilepic 
        LEFT JOIN user USING (userid) 
        WHERE visible=1
         
        ORDER BY posts desc
        LIMIT 0, 18
    
mysql error: Unknown column 'comment' in 'field list'

mysql error number: 1054

Datum: 25.04.2004 21:46:36
Skript: [url]http://www.starlight-board.net/board/album.php[/url] 
sorry i can't find my error, all queries are run :rolleyes:
Hello subu1,

there is no column 'comment' in the user table. Where is this query located and when do you get this error ? Seems something to be wrong with your source code. Did you check again if you implemented all the changes correctly ?

Cheers,

subu1 04-25-2004 07:22 PM
..the query is locatet only in my profile.php

search:

PHP Code:
$profilepic = $DB_site->query_first("
            SELECT userid, dateline
            FROM " . TABLE_PREFIX . "customprofilepic
            WHERE userid = $bbuserinfo[userid]
        "); 
replace it with:

PHP Code:
$profilepic = $DB_site->query_first("
            SELECT userid, dateline, comment, visible
            FROM " . TABLE_PREFIX . "customprofilepic
            WHERE userid = $bbuserinfo[userid]
        ");
        
        $profilepic['comment'] = fetch_censored_text($profilepic['comment']); 
it's correct i don't have 'comment' in the user table

I thing i need a command for my User Table... INSERT INTO `User....only I do not know like



what can i do :nervous:

Pseudomizer 04-25-2004 09:21 PM
Hello subu1,

no, you don't need a column in the user table. The column should be located in your customprofilepic table.

Please try in the phpmyadmin or in mysql command line the following query and tell me what you get:

PHP Code:
SELECT userid, dateline, comment, visible FROM customprofilepic WHERE userid = '1'; 
Cheers,

subu1 04-25-2004 09:29 PM
Quote:
Originally Posted by Pseudomizer
Hello subu1,

no, you don't need a column in the user table. The column should be located in your customprofilepic table.

Please try in the phpmyadmin or in mysql command line the following query and tell me what you get:

PHP Code:
SELECT userid, dateline, comment, visible FROM customprofilepic WHERE userid = '1'; 
Cheers,
ok I see that :disappointed:

Fehler

SQL-Befehl :

SELECT userid, dateline,
COMMENT , visible
FROM customprofilepic
WHERE userid = '1'
LIMIT 0, 30

MySQL meldet:


Unknown column 'COMMENT' in 'field list'

Pseudomizer 04-25-2004 09:36 PM
What do you get for:

PHP Code:
select * from customprofilepic limit 1; 
If you are missing comments, is the rest there ?

Cheers,

subu1 04-25-2004 09:41 PM
now I see this :rolleyes:

Pseudomizer 04-25-2004 09:57 PM
Ok. The solution is easy:

You missed that line during the installation:

PHP Code:
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT NULL AFTER filename; 
Please do this command and all should work fine.

Cheers,


All times are GMT. The time now is 04:20 PM.
Page 11 of 52 « First 910 11 121321 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01603 seconds
  • Memory Usage 1,771KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (8)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete