1 Topic by Ex_cuse (edited by Ex_cuse 2007-05-29 01:44)

  • Registered: 2007-05-29
  • Posts: 3

Topic: Sql Database Help

Hi,

i thought it would be usefull to delete some (for me) unnecessary entries in my sql database (like e.g. the jabber, msn blocks..).
But now im getting some bad errors (unable to fetch user info..), could you please help me to refix it?
I dont have a backup sad
But i think i could add those items manuel?

Thanks.



Edit: i think this is what im missing:

- website
- msn
- jabber
- yahoo
- location

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Sql Database Help

Yeah, you can't just randomly remove columns from the database tables wink

alter table prefixusers add column url varchar(100) after realname
alter table prefixusers add column jabber varchar(75) after url
alter table prefixusers add column msn varchar(50) after icq
alter table prefixusers add column yahoo varchar(30) after aim
alter table prefixusers add column location varchar(30) after yahoo

Replace prefix with your database prefix

3 Reply by Ex_cuse (edited by Ex_cuse 2007-05-29 01:58)

  • Registered: 2007-05-29
  • Posts: 3

Re: Sql Database Help

Is this database file saved on my ftp, too?
I've deleted those entries via phpmyadmin, but it would be easier to complete the table in a file?

thanks so far, for your fast help!

But is there a possibility in not displaying those user information, because those are empty for all my forum users..

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Sql Database Help

A MySQL database isn't a file. Just run those queries I gave you in phpMyAdmin, replacing prefix with your database prefix for PunBB
And as for not displaying the information, you can just look in the files (eg: profile.php, viewtopic.php) where the information is shown and remove the showing part

  • Registered: 2007-05-29
  • Posts: 3

Re: Sql Database Help

It worked,

thank you.
Now i will check those profile.php.. wink


Thanks!