Help with oscommerce and template

[shadycuz]

I bought a template off ebay (big mistake), after much delay from the seller I was finally given a download link and poor instructions. The .tar file was 130 some megs in size and the sql file was weird, I can not get to run on my server. Any help? here is auction http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=170394174965&ssPageName=STRK:MEWNX:IT

 

First I know the SQL file is wrong, here is what is says

 

-- MySQL dump 10.9
--
-- Host: localhost    Database: shadycuz_skateshop
-- ------------------------------------------------------
-- Server version	4.1.22-standard

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

Isnt that normally used to create all the db and setup the tables? I unzipped the .tar into my webroot and ran that sql file. This is what happens www.sk8me.com/index.php

 

Thanks,

Levi

[FIMBLE]

I bought a template off ebay (big mistake), after much delay from the seller I was finally given a download link and poor instructions. The .tar file was 130 some megs in size and the sql file was weird, I can not get to run on my server. Any help? here is auction http://cgi.ebay.com/...e=STRK:MEWNX:IT

 

First I know the SQL file is wrong, here is what is says

 

-- MySQL dump 10.9
--
-- Host: localhost    Database: shadycuz_skateshop
-- ------------------------------------------------------
-- Server version	4.1.22-standard

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

Isnt that normally used to create all the db and setup the tables? I unzipped the .tar into my webroot and ran that sql file. This is what happens www.sk8me.com/index.php

 

Thanks,

Levi

Hi Levi

 

it looks like the install was ok apart from the database, you can try uploading the database with your phpmyadmin, it looks like they have exported the database this way

Nic

[shadycuz]

Hi Levi

 

it looks like the install was ok apart from the database, you can try uploading the database with your phpmyadmin, it looks like they have exported the database this way

Nic

 

I did try that I can give you the read out.

 

Import has been successfully finished, 8 queries executed.
SQL query:
-- MySQL dump 10.9
--
-- Host: localhost Database: shadycuz_skateshop
-- ------------------------------------------------------
-- Server version 4.1.22-standard

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows).

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET @O[...] 

 

I tried loading a sql file from a default install but that doesnt work it gives me the error currently seen on the site, when using this sql file it doesnt create any thing in the DB, no row or tables or anything, just an empty DB.