+ Post New Thread
Page 5 of 20 FirstFirst 12345678915 ... LastLast
Results 61 to 75 of 287
How do you do....it? Thread, Toner inventory Database in Technical; bmdixon: Thanks for letting me know about that. It's a simple fix in the web/css/printmaster.css file. Look for 'div#buttoncontainer input' ...
  1. #61

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,403
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    bmdixon: Thanks for letting me know about that. It's a simple fix in the web/css/printmaster.css file. Look for 'div#buttoncontainer input' and change display: block to display: inline.

    The 'n' is because it uses Wingdings for the circle symbol instead of the HTML character entity • on other pages. I've now fixed this and the updated code is on Github (for both fixes). Download the zip file again, and extract the web/ and views/ folders, overwriting your own.

  2. #62

    Join Date
    Oct 2010
    Location
    Birmingham
    Posts
    91
    Thank Post
    9
    Thanked 11 Times in 11 Posts
    Rep Power
    9
    Hi there. I would like some advice on installing this along with its software requirments. I have Mysql, php and apache installed but I don't know where to go from here or whether I have them all set up correctly. I was looking for a print consumable database and came across this which from what I've read is great. Thanks in advance.

  3. #63

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,403
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    jonathon28: Have you used an existing distribution package that has everything (such as Xampp or WAMP), or have you installed everything separately? Is this on Windows or Linux?

    On the database, you will need to create a new username, a new database, and give access to that database for that user. This can be done easily through a management tool - phpMyAdmin (web-based) and HeidiSQL (Windows) are two good options to choose from.

    Once you have the ability to do that, you should be able to carry out the instructions without any problems:

    1. Create directory on webserver to store files (configure as virtual host or subdir)
    2. Copy all Print Master files to the folder you just created
    3. Create a new directory called session where you extracted the files and make it writeable
    4. Create a new username and database in MySQL
    5. Import the printmaster.sql file into the new database
    6. Edit the $db line in inc/init.php to reflect your database details
    7. Invent your own security (.htaccess, integrated Windows authentication...)

  4. #64

    Join Date
    Oct 2010
    Location
    Birmingham
    Posts
    91
    Thank Post
    9
    Thanked 11 Times in 11 Posts
    Rep Power
    9
    I have installed them seperately on xp but thinking about it I could probably run it on xampp on one of my linux boxes. I know nothing when it comes to this sort of thing but am always trying to learn. I'll have a play and get back to you.

  5. #65

    Join Date
    Oct 2010
    Location
    Birmingham
    Posts
    91
    Thank Post
    9
    Thanked 11 Times in 11 Posts
    Rep Power
    9
    webman:

    right, on a xp machine, I have sucessfully got as far as navigating to the directory of the print manager through the web browser via http://localhost/.

    have also installed heidisql and created a session called session.

    Dont know if this is correct, but have clicked Import at the top > load sql file .... where do i go from here?

    Many thanks.

  6. #66

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,403
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    Quote Originally Posted by jonathon28 View Post
    have also installed heidisql and created a session called session.
    These are separate. You need to create a folder called 'session' in the same folder where you extracted the ZIP file to.

    Quote Originally Posted by jonathon28 View Post
    Dont know if this is correct, but have clicked Import at the top > load sql file
    You need to create a username and a database first. In HeidiSQL:

    1. Tools > Create database. Then...
    2. Tools > User Manager. Add user tab: Enter a username and password. On the right, highlight the database you just created. Click Add User button. Remember this information.
    3. Choose the database from the list on the left of the main window. Then you can go to Import > Load SQL file. Browse to the printmaster.sql, and click OK or Open. It will load into the window - execute the query by clicking the "Play" icon or press F9.


    Where you extracted the files to, you need to edit the inc/init.php file in a text editor. Change the entries in the line starting with $db. This is the format (replace with your own details):

    Code:
    $db = new fDatabase('mysql', 'database-name', 'username', 'password', 'localhost');

  7. #67

    Join Date
    Oct 2010
    Location
    Birmingham
    Posts
    91
    Thank Post
    9
    Thanked 11 Times in 11 Posts
    Rep Power
    9
    Thanks for your help. done that... still only getting the index of / localhost with craigrodway-printmaster-af9843d.

    what should i put in the browser to navigate to printmaster?

  8. #68
    fawkers's Avatar
    Join Date
    Jun 2007
    Location
    Southend
    Posts
    193
    Thank Post
    32
    Thanked 22 Times in 21 Posts
    Blog Entries
    2
    Rep Power
    31
    assuming that you extracted the files to a 'printmaster' folder you should just be able to go to http://localhost/printmaster

  9. #69
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    Is there going to be an "official" update to include costs, or should I try the mod posted earlier?

    I only really want to use this to track how much we spend on toners.

    Its working great so far so would rather do it in a way that can be supported in the future.

  10. #70
    fawkers's Avatar
    Join Date
    Jun 2007
    Location
    Southend
    Posts
    193
    Thank Post
    32
    Thanked 22 Times in 21 Posts
    Blog Entries
    2
    Rep Power
    31
    Hello Zag,

    I've done some work on this over half term, which i will post but its NOT complete and still has quite a few errors.

    PrintMasterTest.zip but you should be able to see where i'm going with it.

    The issue seams to be in the Consumable.php class file around lines 220 - 235
    Last edited by fawkers; 2nd November 2010 at 09:16 AM.

  11. #71
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    25
    Sorry for such a stupid question here

    How can I move the database to a new server I have setup for this?

    Can I just copy the data files in the sql folder located here (C:\ProgramData\MySQL\MySQL Server 5.1\data\ictink)

    Or do I have to use phpmyadmin and export it that way?
    If that is the case, what options do I need to set for the export


    Thanks!

  12. #72
    fawkers's Avatar
    Join Date
    Jun 2007
    Location
    Southend
    Posts
    193
    Thank Post
    32
    Thanked 22 Times in 21 Posts
    Blog Entries
    2
    Rep Power
    31
    You can just go to phpmyadmin, click on the printmaster database, then on the export tab. If your using XAMPP the defult settings should give you a .sql file. Once your've set up your new database you can just go the SQL tab in phpmyadmin and copy paste the .sql file in and runit. That should move everything over for you.

  13. #73
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    25
    ok have just done something a bit different that I found

    I have used the mysql workbench

    Exported the database

    Install sql workbench on the new server, imported the sql file, but have problems when I lanch the site, this is what im getting



    Context
    -------

    $_SERVER: Array
    (
    [PROCESSOR_ARCHITEW6432] => AMD64
    [_FCGI_X_PIPE_] => \\.\pipe\IISFCGI-585ec0dd-ee0d-448e-b1fe-8bca0cef6d4a
    [PHP_FCGI_MAX_REQUESTS] => 10000
    [PHPRC] => C:\Program Files (x86)\PHP\
    [ALLUSERSPROFILE] => C:\ProgramData
    [APPDATA] => C:\Windows\system32\config\systemprofile\AppData\R oaming
    [APP_POOL_CONFIG] => C:\inetpub\temp\apppools\DefaultAppPool.config
    [APP_POOL_ID] => DefaultAppPool
    [CommonProgramFiles] => C:\Program Files (x86)\Common Files
    [CommonProgramFiles(x86)] => C:\Program Files (x86)\Common Files
    [CommonProgramW6432] => C:\Program Files\Common Files
    [COMPUTERNAME] => WEBSERVER
    [ComSpec] => C:\Windows\system32\cmd.exe
    [FP_NO_HOST_CHECK] => NO
    [LOCALAPPDATA] => C:\Windows\system32\config\systemprofile\AppData\L ocal
    [NUMBER_OF_PROCESSORS] => 1
    [OS] => Windows_NT
    [Path] => C:\Windows\system32;C:\Windows;C:\Windows\System32 \Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;
    [PATHEXT] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;. MSC
    [PROCESSOR_ARCHITECTURE] => x86
    [PROCESSOR_IDENTIFIER] => Intel64 Family 6 Model 23 Stepping 6, GenuineIntel
    [PROCESSOR_LEVEL] => 6
    [PROCESSOR_REVISION] => 1706
    [ProgramData] => C:\ProgramData
    [ProgramFiles] => C:\Program Files (x86)
    [ProgramFiles(x86)] => C:\Program Files (x86)
    [ProgramW6432] => C:\Program Files
    [PSModulePath] => C:\Windows\system32\WindowsPowerShell\v1.0\Modules \
    [PUBLIC] => C:\Users\Public
    [SystemDrive] => C:
    [SystemRoot] => C:\Windows
    [TEMP] => C:\Windows\TEMP
    [TMP] => C:\Windows\TEMP
    [USERDOMAIN] => OCKENDON
    [USERNAME] => WEBSERVER$
    [USERPROFILE] => C:\Windows\system32\config\systemprofile
    [windir] => C:\Windows
    [FCGI_ROLE] => RESPONDER
    [HTTP_CONNECTION] => Keep-Alive
    [HTTP_CONTENT_LENGTH] => 0
    [HTTP_ACCEPT] => */*
    [HTTP_ACCEPT_ENCODING] => gzip, deflate
    [HTTP_ACCEPT_LANGUAGE] => en-GB
    [HTTP_HOST] => localhost
    [HTTP_USER_AGENT] => Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET4.0C; .NET4.0E; .NET CLR 3.5.30729; .NET CLR 3.0.30729)
    [IIS_UrlRewriteModule] => 7.1.0871.0
    [APPL_MD_PATH] => /LM/W3SVC/1/ROOT
    [APPL_PHYSICAL_PATH] => C:\inetpub\wwwroot\
    [AUTH_TYPE] => {empty_string}
    [AUTH_PASSWORD] => {empty_string}
    [AUTH_USER] => {empty_string}
    [CERT_COOKIE] => {empty_string}
    [CERT_FLAGS] => {empty_string}
    [CERT_ISSUER] => {empty_string}
    [CERT_SERIALNUMBER] => {empty_string}
    [CERT_SUBJECT] => {empty_string}
    [CONTENT_LENGTH] => 0
    [CONTENT_TYPE] => {empty_string}
    [DOCUMENT_ROOT] => C:\inetpub\wwwroot
    [GATEWAY_INTERFACE] => CGI/1.1
    [HTTPS] => off
    [HTTPS_KEYSIZE] => {empty_string}
    [HTTPS_SECRETKEYSIZE] => {empty_string}
    [HTTPS_SERVER_ISSUER] => {empty_string}
    [HTTPS_SERVER_SUBJECT] => {empty_string}
    [INSTANCE_ID] => 1
    [INSTANCE_NAME] => DEFAULT WEB SITE
    [INSTANCE_META_PATH] => /LM/W3SVC/1
    [LOCAL_ADDR] => ::1
    [LOGON_USER] => {empty_string}
    [PATH_TRANSLATED] => C:\inetpub\wwwroot\ictink\index.php
    [QUERY_STRING] => {empty_string}
    [REMOTE_ADDR] => ::1
    [REMOTE_HOST] => ::1
    [REMOTE_PORT] => 49490
    [REMOTE_USER] => {empty_string}
    [REQUEST_METHOD] => GET
    [REQUEST_URI] => /ictink/
    [SCRIPT_FILENAME] => C:\inetpub\wwwroot\ictink\index.php
    [SCRIPT_NAME] => /ictink/index.php
    [SERVER_NAME] => localhost
    [SERVER_PORT] => 80
    [SERVER_PORT_SECURE] => 0
    [SERVER_PROTOCOL] => HTTP/1.1
    [SERVER_SOFTWARE] => Microsoft-IIS/7.5
    [URL] => /ictink/index.php
    [ORIG_PATH_INFO] => /ictink/index.php
    [PHP_SELF] => /ictink/index.php
    [REQUEST_TIME] => 1288700024

    )

    $_POST: Array
    (
    )

    $_GET: Array
    (
    )

    $_FILES: Array
    (
    )

    $_SESSION: Array
    (
    )

    $_COOKIE: Array
    (
    )
    Warning-------{doc_root}\ICTInk\index.php(22): include_once('C:\inetpub\wwwr...'){doc_root}\ICTIn k\inc\init.php(17): fSession:pen(){doc_root}\ICTInk\inc\flourish\fSession.php(3 06): session_start()[internal function]session_start(): open(C:\inetpub\wwwroot\ICTInk\session\\sess_fp335 ju0kg3murcl1peuk92367, O_RDWR) failed: Permission denied (13)Warning-------{doc_root}\ICTInk\index.php(22): include_once('C:\inetpub\wwwr...'){doc_root}\ICTIn k\inc\init.php(17): fSession:pen(){doc_root}\ICTInk\inc\flourish\fSession.php(3 06): session_start()[internal function]session_start(): Cannot send session cookie - headers already sent by (output started at C:\inetpub\wwwroot\ICTInk\inc\flourish\fCore.php:7 40)Warning-------{doc_root}\ICTInk\index.php(22): include_once('C:\inetpub\wwwr...'){doc_root}\ICTIn k\inc\init.php(17): fSession:pen(){doc_root}\ICTInk\inc\flourish\fSession.php(3 06): session_start()[internal function]session_start(): Cannot send session cache limiter - headers already sent (output started at C:\inetpub\wwwroot\ICTInk\inc\flourish\fCore.php:7 40)



    after the error message it brings up part of the site, after that more errors







    Warning-------[internal function]Unknown: open(C:\inetpub\wwwroot\ICTInk\session\\sess_fp335 ju0kg3murcl1peuk92367, O_RDWR) failed: Permission denied (13)Warning-------[internal function]Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\inetpub\wwwroot\ICTInk\session\)

  14. #74

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,403
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    p-dave: Ensure the session folder is created and writeable by the webserver.

    Others: Re: costs. At the moment, I'm not looking at developing the costs feature due to higher priorities (private work, Classroombookings). I agree it would be a good feature to have, and probably one day I'll do it; just not right now
    Last edited by webman; 2nd November 2010 at 12:46 PM.

  15. #75
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    25
    session folder should be writable

    I have even enabled iis_users and iss_wpg on the www root folder just in case

    And have tried even now exporting and importing the database using phpmyadmin

    Any other ideas?


    I should note, that this is the first site im trying on the new server, php seems to work, so Im assume php is working

    Is there any certain php extensions you use for printmaster?

    I know phpmyadmin comes up about missing mcrupt extension
    Last edited by pritchardavid; 2nd November 2010 at 12:53 PM.

SHARE:
+ Post New Thread
Page 5 of 20 FirstFirst 12345678915 ... LastLast

Similar Threads

  1. OCS Inventory
    By Geoff in forum Downloads
    Replies: 5
    Last Post: 3rd June 2011, 08:40 AM
  2. Inventory
    By school in forum Scripts
    Replies: 2
    Last Post: 3rd June 2010, 02:18 PM
  3. Inventory
    By mmoseley in forum Network and Classroom Management
    Replies: 15
    Last Post: 20th June 2007, 12:31 PM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. inventory system
    By bjg5858 in forum General Chat
    Replies: 2
    Last Post: 11th July 2006, 09:10 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •