PC Repair Tracker Help

[xxsilk109xx]

Ok ok, before I get criticized, I admit I didnt quite understand what I was getting into, so now you can roll on the punches lol

I purchased the pc repair tracker, thinking that it was a stand alone program that was based on php/mysql that was already setup.

I admit that I dont know anything about php/mysql so I am like a deer in the headlights trying to get this up and running.

So if someone uses this or knows an easy way or has a tutorial or something on what I need to do to get this running it would help a lot.

I dont have a website as of yet so I dont have the tools that are explained in the install read me file.

Thanks for the help, hope I didnt waste 125 bucks!

 

[rapidcom]

Email Luke at

info@pcrepairtracker.com

and he'll help you set everything up, he offered to remote into my computer and help if I needed it when I purchased PCRT.

 

[Titan-vds]

Don't worry you didn't waste your money. Download xampp and go from there. Its just a matter of extracting the files/folders to the htdocs folder and importing the SQL database. Xampp has an admin interface for you to use. Don't forget to modify your deps file.

 

[xxsilk109xx]

well i downloaded xampp, extracted the pc repair tracker zip file to the htdocs folder.

Im not sure how to import the sql database...

 

[4ycr]

try these for some help

http://www.ehow.com/how_2036644_import-sql-database.html
or
http://assets.webassist.com/how-tos/importing_sql.pdf

 

[xxsilk109xx]

Ok I got myself to the localhost/phpmyadmin page

it told me to add a password, i did that and now its telling me its trying to login without a password and it wont let me..how do i log out so that I can do this over and actually type the login?

 

[xxsilk109xx]

Ok well here it is:
1. I dont have a website.
2. I installed XAMPP
3. I have no idea in hell what I am doing.

Would anyone like to set this up for me and I can pay you??

lol either that or i am just going to have to chalk it up as a loss because I am in over my head with this stuff..

 

[TopLevelComp]

Ok well here it is:
1. I dont have a website.
2. I installed XAMPP
3. I have no idea in hell what I am doing.

Would anyone like to set this up for me and I can pay you??

lol either that or i am just going to have to chalk it up as a loss because I am in over my head with this stuff..

I think XAMPP was the first mistake.

I use EasyPHP.

http://www.easyphp.org/

Install EasyPHP, I installed it to C:/ for ease of use.

Put the PCRT files into the www folder inside EasyPHP.

Right click on EasyPHP icon, go to Configuration, click on PHPMyAdmin, or just open your internet browser, and put this into the address bar:
http://127.0.0.1:8888/home/mysql/

Once there, click on "Import" and import the SQL file if they have one.

 

[xxsilk109xx]

Hey TopLevelComp - Thanks for the tips!

I got to where I hit import, i point it to the SQL file that I put into the www folder and then I hit import and I get the following error

Error

SQL query:

--
-- Database: `pcshoptracker`
--
-- --------------------------------------------------------
CREATE TABLE `assetphotos` (
`assetphotoid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`pcid` int( 11 ) NOT NULL ,
`photofilename` text NOT NULL ,
`highlight` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `assetphotoid` )
) ENGINE = MYISAM ;

MySQL said: Documentation
#1046 - No database selected

 

[TopLevelComp]

Hey TopLevelComp - Thanks for the tips!

I got to where I hit import, i point it to the SQL file that I put into the www folder and then I hit import and I get the following error

Error

SQL query:

--
-- Database: `pcshoptracker`
--
-- --------------------------------------------------------
CREATE TABLE `assetphotos` (
`assetphotoid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`pcid` int( 11 ) NOT NULL ,
`photofilename` text NOT NULL ,
`highlight` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `assetphotoid` )
) ENGINE = MYISAM ;

MySQL said: Documentation
#1046 - No database selected

Did you already create the pcshoptracker database?

If not, if you click on the little house on the top left of the screen, it should take you back to the home screen for PHPMyAdmin. When you get there, about the middle of the screen you should see: "Create new database" Below that should be an area to input text, type in "pcshoptracker" (Without the quotes of course.)

Once that is created, on the left hand side of the screen, it should list "pcshoptracker"
Click on that, then do the Import, and see if that works.

 

[16k_zx81]

I think you are bringing yourself a world of unnecessary pain.

Grab a $1 domain name. Hosting can be got for about $20.

Thats it - you're set.

Too much messing around with local install when site install can be done so cheaply.

- unless, of course, you are just loving the troubleshooting figuring out the local setup as a hack, in which case, I totally relate! and please disregard the above

 

[xxsilk109xx]

Ok I am thinking about getting a domain and a host but I just got it loaded successfully TopLevelComp..

So whats next how do I use it?

 

[Titan-vds]

Edit the deps.php files in both the repair and store directory to your liking. You will need to
specify your database name, username and passwords in each of these two files. Some of the settings in these
files are arrays, be careful to preserve the syntax.
Go to localhost/repair. You should have the default username and password.

 

[xxsilk109xx]

Ok i edited the deps file to my information and specs.

when I type localhost/repair nothing comes up nor does localhost/pcshoptracker

i named the database pcshoptracker

ps...thanks again so much for your help without you i would be lost in this!

 

[Titan-vds]

I sent you a pm.
...............

 

[xxsilk109xx]

i replied back

.......................

 

[TenYardFight]

I know I'm going to feel like an idiot when someone points this out to me, but where do I change the status fields named "User Defined 1" and User Defined 2"?

 

[Xander]

I know I'm going to feel like an idiot when someone points this out to me, but where do I change the status fields named "User Defined 1" and User Defined 2"?

..repair/deps.php

Starts at Line 33 in mine.