1 Topic by XuMiX (edited by XuMiX 2005-03-30 06:04)

  • XuMiX
  • Senior Member
  • Offline
  • From: Russia.Novosibirsk.ToStreet()
  • Registered: 2004-05-17
  • Posts: 130

Topic: Error in admin_groups.php

go to line 243-245 (i don't know exactly, my file is modded):

$result = $db->query('SELECT g_id FROM '.$db->prefix.'groups WHERE g_title= \''.$db->escape($title).'\' && g_id != \''.$_POST['group_id'].'\'') or error('Unable to check group title collision', __FILE__, __LINE__, $db->error());

should be 

$result = $db->query('SELECT g_id FROM '.$db->prefix.'groups WHERE g_title= \''.$db->escape($title).'\' AND g_id != \''.$_POST['group_id'].'\'') or error('Unable to check group title collision', __FILE__, __LINE__, $db->error());

XuMiX's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Error in admin_groups.php

Got it. It should still work in MySQL though.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

3 Reply by XuMiX

  • XuMiX
  • Senior Member
  • Offline
  • From: Russia.Novosibirsk.ToStreet()
  • Registered: 2004-05-17
  • Posts: 130

Re: Error in admin_groups.php

yes, seems so, but i use PostgreSQL smile
mysql is TOO polite with some mistakes... pgsql teaches to be more strict and accurate

XuMiX's Website

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Error in admin_groups.php

thats why no one uses pgsql tongue

FluxBB.
Connorhd.co.uk.

Connorhd's Website

5 Reply by XuMiX

  • XuMiX
  • Senior Member
  • Offline
  • From: Russia.Novosibirsk.ToStreet()
  • Registered: 2004-05-17
  • Posts: 130

Re: Error in admin_groups.php

hehe, that?s why lame use mysql tongue
BTW if i want some mysql functions - i just get plPHP and write some, so what would you do with mysql ? smile

XuMiX's Website