Member Avatar for UnknownZ

Please help..I found an old script which offer members so they can add buddylist, but I get this error when I want to add buddy:

MySQL Query Error: UPDATE members SET buddylist='demo,' WHERE id='1' LIMIT 1; 
Returned Error: Unknown column 'buddylist' in 'field list'

I locate back the buddylist.php and I have this line:

if($newbuds != ""){
$newbuds = $User->userdata['buddylist'].$newbuds;
$Db->query("UPDATE members SET buddylist='{$newbuds}' WHERE id='{$User->id}' LIMIT 1;");


        }

Thanks in advance..

Edited by happygeek because: fixed formatting
  • 3 Contributors
  • 4 Replies
  • 150 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by UnknownZ

Recommended Answers

All 4 Replies

Member Avatar for PoA

Make sure 'buddylist' in the table. If there is still error, then please provide your table structure.

Member Avatar for UnknownZ

Thanks, I forgot to add it, and it works now.
I have another error, could you advise me what should I do?

Fatal error: Cannot redeclare getmicrotime() (previously declared in /home/mysite/public_html/start.php:10) in /home/mysite/public_html/start.php on line 9
//------------------------------
	// Some Stuff for Parse Time management:
	//------------------------------
	function getmicrotime(){
		list($usec, $sec) = explode(" ",microtime());
		return ((float)$usec + (float)$sec);
	}
	define ("START_TIME", getmicrotime());
	function parsetime(){
		define ("END_TIME", getmicrotime());
		return END_TIME-START_TIME;
	}
Member Avatar for zippee

Apperently you have declare/use the getmicrotime() function in the "start.php" file which include in the current file. The same function is declare in line 9 in start.php.

Member Avatar for UnknownZ

the getmicrotime() function is only in the http://www.mysite.com/start.php ..

It was okay, when I click on http://www.mysite.com/admin/index.php
but when I want to access http://www.mysite.com/admin/sources/display.php
that is where I get the error:

Fatal error: Cannot redeclare getmicrotime() (previously declared in /home/mysite/public_html/start.php:10) in /home/mysite/public_html/start.php on line 9

Here is the code in display.php

<?php
	/* Check user didn't load this file */
	if($Display->logged() != TRUE || !is_object($Display)) die("Fatal Error in script execution");
	
	/* Define Sub-Actions */
	$SubActions['templates'] = "Edit Templates";	
	$SubActions['config'] = "Display Config";

?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.