Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > MyDNSConfig > General
Reload this Page Error: Unknown column 'active' in 'field list'
Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
Page 2 of 3 1 2 3
 
Thread Tools Display Modes
  #11  
Old 23rd February 2006, 01:06
TWC TWC is offline
Junior Member
  
Join Date: Feb 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default
I still get the same error on any system or dns selection.

Tc
Reply With Quote
Sponsored Links
  #12  
Old 23rd February 2006, 07:53
falko falko is offline
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,685
Thanks: 1,899
Thanked 2,599 Times in 2,448 Posts
Default
Can you change the admin record so that it looks like mine?

Why did your admin user have the userid 3?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #13  
Old 24th February 2006, 00:19
TWC TWC is offline
Junior Member
  
Join Date: Feb 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default
I have modified the sys_user and confirmed the sys_userid | sys_groupid | sys_perm_user | sys_perm_group | records in soa and rr match. I have reproduced this on two different systems. The same error on system or dns selection.

Error:
You don't have the permission to view this record or this record does not exist!

My current sys_user:

Code:
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
| userid | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | username | passwort                         | modules   | startmodule | app_theme | typ   | active | name | vorname | unternehmen | strasse | ort | plz | land | email | url | telefon | fax | language | groups | default_group |
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
|      1 |          1 |           0 | riud          | riud           |                | admin    | 883a8869eeaf7ba467da2a945d7771e2 | admin,dns | dns         | default   | admin |      1 |      |         |             |         |     |     |      |       |     |         |     | en       |        |             0 |
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
Any suggestions or do you need anything on our end; willing to help.

Tc
Last edited by falko; 24th February 2006 at 12:31.
Reply With Quote
  #14  
Old 24th February 2006, 15:30
till till is online now
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 32,069
Thanks: 697
Thanked 4,248 Times in 3,260 Posts
Default
For me the myDNSConfig database dump works fine. Can you please send me your complete mysql database as asql-dump attached to a pm, then i will try to find the error.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #15  
Old 26th April 2006, 22:59
Spode Spode is offline
Junior Member
  
Join Date: Apr 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Hi,

I'm having exactly the same problem as above. Doing the ALTER statement fixed the first issue, but now I'm stuck not being able to edit a record as I'm told I don't have permissions and my user table looks identical to yours.

Did you ever solve this?

Spode
Reply With Quote
  #16  
Old 27th April 2006, 11:57
Spode Spode is offline
Junior Member
  
Join Date: Apr 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Upon turning on displaying of PHP errors, the following appear that don't actually cause execution to stop.

Notice: Undefined property: app::$listform_actions in /var/www/html/mydns/lib/app.inc.php on line 61

Notice: Undefined property: app::$tpl in /var/www/html/mydns/lib/classes/listform_actions.inc.php on line 48

Notice: Undefined property: app::$tpl in /var/www/html/mydns/lib/app.inc.php on line 61

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /var/www/html/mydns/lib/classes/tpl.inc.php on line 451

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /var/www/html/mydns/lib/classes/tpl.inc.php on line 461

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /var/www/html/mydns/lib/classes/tpl.inc.php on line 471

Notice: Undefined index: template in /var/www/html/mydns/lib/classes/tpl_ini.inc.php on line 89

Notice: Undefined index: template in /var/www/html/mydns/lib/classes/tpl_ini.inc.php on line 89

Notice: Undefined property: app::$listform in /var/www/html/mydns/lib/classes/listform_actions.inc.php on line 49

Notice: Undefined property: app::$listform in /var/www/html/mydns/lib/app.inc.php on line 61

Notice: Undefined index: search_origin in /var/www/html/mydns/lib/classes/listform.inc.php on line 86

Notice: Undefined index: search_ns in /var/www/html/mydns/lib/classes/listform.inc.php on line 86

Notice: Undefined index: search_ttl in /var/www/html/mydns/lib/classes/listform.inc.php on line 86

Notice: Undefined index: search_active in /var/www/html/mydns/lib/classes/listform.inc.php on line 80

Notice: Undefined index: search_active in /var/www/html/mydns/lib/classes/listform.inc.php on line 80

Notice: Undefined index: search_origin in /var/www/html/mydns/lib/classes/listform.inc.php on line 95

Notice: Undefined index: search_ns in /var/www/html/mydns/lib/classes/listform.inc.php on line 95

Notice: Undefined index: search_ttl in /var/www/html/mydns/lib/classes/listform.inc.php on line 95

Notice: Undefined index: search_active in /var/www/html/mydns/lib/classes/listform.inc.php on line 95

Notice: Undefined index: page_params in /var/www/html/mydns/lib/classes/listform.inc.php on line 138

Notice: Undefined variable: seiten in /var/www/html/mydns/lib/classes/listform.inc.php on line 142

Notice: Undefined index: show_page_back in /var/www/html/mydns/lib/classes/listform.inc.php on line 155

Notice: Undefined index: show_page_next in /var/www/html/mydns/lib/classes/listform.inc.php on line 157
Last edited by Spode; 27th April 2006 at 12:01.
Reply With Quote
  #17  
Old 27th April 2006, 12:28
falko falko is offline
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,685
Thanks: 1,899
Thanked 2,599 Times in 2,448 Posts
Default
Set allow_call_time_pass_reference to true in your php.ini and restart Apache.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #18  
Old 27th April 2006, 12:30
Spode Spode is offline
Junior Member
  
Join Date: Apr 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Yeah, I thought of that. But I still get this:

I'm trying to debug it myself, but I'm not getting anywhere quickly.

Notice: Undefined property: app::$listform_actions in /var/www/html/mydns/lib/app.inc.php on line 61

Notice: Undefined property: app::$tpl in /var/www/html/mydns/lib/classes/listform_actions.inc.php on line 48

Notice: Undefined property: app::$tpl in /var/www/html/mydns/lib/app.inc.php on line 61

Notice: Undefined index: template in /var/www/html/mydns/lib/classes/tpl_ini.inc.php on line 89

Notice: Undefined index: template in /var/www/html/mydns/lib/classes/tpl_ini.inc.php on line 89

Notice: Undefined property: app::$listform in /var/www/html/mydns/lib/classes/listform_actions.inc.php on line 49

Notice: Undefined property: app::$listform in /var/www/html/mydns/lib/app.inc.php on line 61

Notice: Undefined index: search_origin in /var/www/html/mydns/lib/classes/listform.inc.php on line 86

Notice: Undefined index: search_ns in /var/www/html/mydns/lib/classes/listform.inc.php on line 86

Notice: Undefined index: search_ttl in /var/www/html/mydns/lib/classes/listform.inc.php on line 86

Notice: Undefined index: search_active in /var/www/html/mydns/lib/classes/listform.inc.php on line 80

Notice: Undefined index: search_active in /var/www/html/mydns/lib/classes/listform.inc.php on line 80

Notice: Undefined index: search_origin in /var/www/html/mydns/lib/classes/listform.inc.php on line 95

Notice: Undefined index: search_ns in /var/www/html/mydns/lib/classes/listform.inc.php on line 95

Notice: Undefined index: search_ttl in /var/www/html/mydns/lib/classes/listform.inc.php on line 95

Notice: Undefined index: search_active in /var/www/html/mydns/lib/classes/listform.inc.php on line 95

Notice: Undefined index: page_params in /var/www/html/mydns/lib/classes/listform.inc.php on line 138

Notice: Undefined variable: seiten in /var/www/html/mydns/lib/classes/listform.inc.php on line 142

Notice: Undefined index: show_page_back in /var/www/html/mydns/lib/classes/listform.inc.php on line 155

Notice: Undefined index: show_page_next in /var/www/html/mydns/lib/classes/listform.inc.php on line 157
Reply With Quote
  #19  
Old 27th April 2006, 16:53
falko falko is offline
Super Moderator
  
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,685
Thanks: 1,899
Thanked 2,599 Times in 2,448 Posts
Default
These are just notices. Set the error level to its previous state, and it should work.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #20  
Old 27th April 2006, 17:21
Spode Spode is offline
Junior Member
  
Join Date: Apr 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default
Of course they are. LOL. Silly me.

However, I'm still getting the permissions error.
Reply With Quote
Reply
Page 2 of 3 1 2 3

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail problem Mahir Installation/Configuration 16 24th April 2007 20:22
Logging in to isp config Jrdgames General 43 6th March 2006 19:04
Totally Confused?? :( kingtux Installation/Configuration 7 9th February 2006 22:14
What is IP list? Hint: Only put one IP per line in the field IP List. danf.1979 Installation/Configuration 3 21st December 2005 23:05
Crontab Joe-Montana HOWTO-Related Questions 2 23rd October 2005 23:54


All times are GMT +2. The time now is 12:26.

Contact Us - HowtoForge - Linux Howtos and Tutorials - Archive - Top

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.