ATutor

ATConfig tryed everythink

• dannyboy
  

  2009-08-19 11:20:22

  ATConfig tryed everythink

  Things to describe:
  Operating system ATutor is installed on -
  ATutor version - ATutor
  PHP version - 5.2.10
  MySQL version - mysql-5.1.37
  Webserver & version - Apache 2.2.13
  Web browser being used - IE8 and FF
  ...and anything else relevant -
  
  right where to start
  ive keep getting
  Error
  * Table AT_config creation failed.
  
  ive provided an info.php file
  
  ive uninstalled all and reinstalled everythink
  
  ive set up a new database and use default
  
  ive done everythink you walkthoughs and handbooks tell me to do
  
  i have no idea what doing it ive read all other topics about this and still no luck any help would be great as am going mad and insane lol :P any other info just ask and i provide it

• greg
  

  2009-08-19 12:37:29

  Re: AT_Config tryed everythink

  My only remaining suggestion is try installing ATutor on a different system, preferably Linux.

• dannyboy
  

  2009-08-19 12:44:35

  Re: AT_Config tryed everythink

  sorry to say but there must be a bug in the atutor_schema.SQL file i can i roll back to the verson back 1.6.2 i had no problems installing it then updateing it to 1.6.3 no problems so there must be a bug in the 1.6.3 file you might want to check that greg
  
  [reply][b]In reply to:[/b]
  My only remaining suggestion is try installing ATutor on a different system, preferably Linux.
  [op]forums/view.php?fid=7;pid=18376;page=1#18379[/op][/reply]

• greg
  

  2009-08-19 13:03:44

  Re: AT_Config tryed everythink

  Its more likely a problem with something on your system, perhaps a particular version of php/apache/mysql. We've installed dozens of 1.6.3 systems without a problem. As have others.
  
  The SQL in the schema file is fine. I suggest you try running it manually in something like phpMyAdmin to see if it will run.

• dannyboy
  

  2009-08-19 18:04:12

  Re: AT_Config tryed everythink

  ok ive managed to get at_config installed useing phpmyadmin way but when i use the auto set up it still doesnt want to work still says Error AT_config
  
  is there a full guide to installing it manually and
  is it my PHP.ini file playing up cloud you take a look and recommend the settings

• dannyboy
  

  2009-08-19 18:43:41

  Re: AT_Config tryed everythink

  is it any think to do with me useing the mysql community sever? do i need the enterprize verson?

• dannyboy
  

  2009-08-19 18:45:00

  Re: AT_Config tryed everythink

  My Setup
  MySQL
  Server: localhost via TCP/IP
  Server version: 5.1.37-community
  Protocol version: 10
  MySQL charset: UTF-8 Unicode (utf8)
  Web server
  Apache/2.2.13 (Win32) PHP/5.2.10
  MySQL client version: 5.0.51a
  PHP extension: mysql

• dannyboy
  

  2009-08-19 18:50:01

  Re: AT_Config tryed everythink

  hers my Server variables and settings allthe help i can get is thankful i do like your product and its what i need
  
  i can fix it my self its i just need to be pointed the right way where the error is
  
  what i cant work out all other app's i have work fine even the Test.php on this forum posted by harris works perfect

• roberto_itape
  

  2009-08-20 01:00:14

  Re: AT_Config tryed everythink

  Things to describe:
  Operating system ATutor is installed on - Windows Vista
  ATutor version - 1.6.3
  PHP version - 5.2.10
  MySQL version - 5.1.11
  Webserver & version - IIS 7 LOCALHOST
  
  ...and anything else relevant -
  
  Mr Greg, please look at this:
  
  I put this command in MySQL Query Browser
  [green]
  CREATE TABLE `config` (
  `name` CHAR( 30 ) NOT NULL default '',
  `value` TEXT NOT NULL default '',
  PRIMARY KEY ( `name` )
  ) TYPE = MYISAM;
  [/green]
  And after execution
  [red]
  BLOB/TEXT column 'value' can't have a default value [/red]
  
  Then I change for:
  `value` TEXT NOT NULL,
  
  And after the execution the table config was created.
  
  Is really this the solution?
  
  Thank you.
  
  Roberto

• cindy
  

  2009-08-20 08:49:36

  Re: AT_Config tryed everythink

  Yes, this is one of the solutions.
  
  The error is reported because your mysql sql_mode is set to "strict". Another solution is to remove mysql strict sql_mode.

• dannyboy
  

  2009-08-20 09:46:17

  Re: AT_Config tryed everythink

  ok i finaly got it all installed but am getting all this on the login page
  advisement please :D
  
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 75
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 88
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 103
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 179
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 213
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 1225
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\mysql_connect.inc.php on line 20
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\mysql_connect.inc.php on line 26
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Language\LanguageManager.class.php on line 77
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Language\LanguageManager.class.php on line 280
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 276
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 284
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 287
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 290
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 293
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Savant2\Savant2.php on line 1422
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Savant2\Savant2.php on line 1624
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Savant2\Savant2.php on line 1763
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 59
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 85
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 105
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 133
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 135
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 249
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\mods\_standard\rss_feeds\module.php on line 61
  
  Warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\login.php on line 75
  
  Warning: Cannot modify header information - headers already sent by (output started at C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php:59) in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\login.php on line 143

• dannyboy
  

  2009-08-20 09:51:09

  Re: AT_Config tryed everythink

  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 75
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 88
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 103
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 179
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 213
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\vitals.inc.php on line 1225
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\mysql_connect.inc.php on line 20
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\mysql_connect.inc.php on line 26
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Language\LanguageManager.class.php on line 77
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Language\LanguageManager.class.php on line 280
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 276
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 284
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 287
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 290
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\UrlRewrite\UrlRewrite.class.php on line 293
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Savant2\Savant2.php on line 1422
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Savant2\Savant2.php on line 1624
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Savant2\Savant2.php on line 1763
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 59
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 85
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 105
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 133
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 135
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php on line 249
  
  Deprecated: Assigning the return value of new by reference is deprecated in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\mods\_standard\rss_feeds\module.php on line 61
  
  Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '1.0/DST' instead in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\output.inc.php on line 177
  
  Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '1.0/DST' instead in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\output.inc.php on line 180
  
  Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '1.0/DST' instead in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\output.inc.php on line 188
  
  Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '1.0/DST' instead in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\output.inc.php on line 188
  
  Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '1.0/DST' instead in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\output.inc.php on line 188
  
  Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '1.0/DST' instead in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\lib\output.inc.php on line 188
  
  Warning: Cannot modify header information - headers already sent by (output started at C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Module\Module.class.php:59) in C:\Server\www\myserver.dev\public_html\ATutor-1.6.2\ATutor\include\classes\Language\Language.class.php on line 123

• greg
  

  2009-08-20 09:54:49

  Re: AT_Config tryed everythink

  Why not install ATutor 1.6.3?
  
  And if you have an Apache server available, use it instead. IIS support for php leave a bit to ,be desired.

• dannyboy
  

  2009-08-20 09:59:25

  Re: AT_Config tryed everythink

  it is on apache server and its got php 5.3.0 on it
  
  what is my issue? can you explan
  
  [reply][b]In reply to:[/b]
  Why not install ATutor 1.6.3?
  
  And if you have an Apache server available, use it instead. IIS support for php leave a bit to ,be desired.
  [op]forums/view.php?fid=7;pid=18376;page=1#18402[/op][/reply]

• dannyboy
  

  2009-08-20 10:05:14

  Re: AT_Config tryed everythink

  i did have IIS installed well before know but i think i uninstalled it all or havent i?

• cindy
  

  2009-08-20 10:09:21

  Re: AT_Config tryed everythink

  Although passing by reference is deprecated in PHP5, it's working but reporting warning when your PHP is running in E_STRICT mode.
  
  The solution is turning off E_STRICT in php.ini.

• dannyboy
  

  2009-08-20 10:40:41

  Re: AT_Config tryed everythink (solved)

  TY cindy its fully working now i lov ya ! at least sum1 told me what to do to fix it :D TYTYTYTYTY

• dannyboy
  

  2009-08-20 10:49:34

  Re: AT_Config tryed everythink (solved)

  and i would like to install it to 1.6.3 but it still having them issues in hateing the AT_config
  
  how and why idont know but it should because i got 1.6.2 installed and working fully

• greg
  

  2009-08-20 10:56:43

  Re: AT_Config tryed everythink

  You can avoid old issues like those you are experiencing by installing the newest version of ATutor. You should always be using the latest version.
  
  I mistook roberto's system for yours. Nevermind. I see you are using Apache.

• cindy
  

  2009-08-20 10:59:56

  Re: AT_Config tryed everythink (solved)

  As said, to get rid of the failure on creating AT_config table in 1.6.3, either take your mysql off the strict mode, or modify install/db/atutor_schema.sql to remove "default ''" from line "`value` TEXT NOT NULL default '',".
  
  1.6.2 didn't complaint at AT_config is because at then "value" field in AT_config is defined as type "CHAR( 255 )" instead of "TEXT".
  
  1.6.2 and 1.6.3 have no problem running on same host as long as they use different databases.

• dannyboy
  

  2009-08-20 11:01:39

  Re: AT_Config tryed everythink (solved)

  right ty for explaning i will give it a shot cindy

• dannyboy
  

  2009-08-20 11:30:54

  Re: AT_Config tryed everythink (solved)

  yup it worked this time when i changed it in myphpadmin
  
  thanks all for the info and help

• roberto_itape
  

  2009-08-20 12:18:31

  Re: AT_Config tryed everythink (solved)

  With IIS 7 really dont get success to complete the installation.
  
  Then WITHOUT ANY CHANGE in ATutor 1.6.3 I upload the files for my host:
  
  ATutor Version: 1.6.3 (build r8760 - 2009-07-23 15:43:12)
  Operating System: Linux 2.6.18-128.1.1.el5PAE #1 SMP Mon Jan 26 14:18:23 EST 2009 i686
  Web Server: Apache/2.2.11 (Locaweb)
  PHP Version: 5.2.9
  MySQL Version: 5.0.77.d8-ourdelta-sail-log
  Optional URL: http://www.britishland.com.br/tutor/
  
  And Im happy :D . ATutor install and work FINE!!!!
  
  Congratulations!