FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


install problem





Kurosaki-Ichigo
Ok so i got this script and now that im installing it it gives me an error.

The Read Me File :
Quote:

======================================================================================
HotWebScripts.com Video Player Alegria V1.0
======================================================================================

1. Requirements

- Apache Webserver
- PHP 5+
- MySQL 4.1+
- Zend Optimizer
- mod_rewrite enabled
- GD Library enabled

2. Installation

- Upload all the files to your FTP
- Set the rights for the templates_c folder and subfolders to 777
- Set the rights for the uploads folder and subfolders to 777
- Open the file /includes/config.inc.php
- Set the properties for your database and license in this file and save it
- Start up your phpMyAdmin or other MySQL compatible admin tool
- Create a database for the Player
- Run the file Flash_Video_Alegria_SQL_INSTALL.sql in the desired database


So im stuck at this part :
Quote:
- Create a database for the Player
- Run the file


I dont know exactly what to do. I was guessing i have put the "Flash_Video_Alegria_SQL_INSTALL.sql " text into the sql querry and run it but when i do that it gives me this error :

Quote:

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 29 Mei 2006 om 15:27
-- Server versie: 4.1.11
-- PHP Versie: 5.1.2
--
-- Database: `scripts_videodev`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `settings`
--
CREATE TABLE `settings` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`seo_title` varchar( 255 ) NOT NULL default '',
`seo_keywords` varchar( 255 ) NOT NULL default '',
`seo_description` varchar( 255 ) NOT NULL default '',
`contact_sendto` varbinary( 255 ) NOT NULL default '',
`contact_pagetxt` text NOT NULL ,
`contact_active` tinyint( 1 ) NOT NULL default '0',
`gallery_active` tinyint( 1 ) NOT NULL default '0',
`faq_active` tinyint( 1 ) NOT NULL default '0',
`news_active` tinyint( 1 ) NOT NULL default '0',
`shop_active` tinyint( 1 ) NOT NULL default '0',
`features_active` tinyint( 1 ) NOT NULL default '0',
`paypal_id` varchar( 255 ) NOT NULL default '',
`paypal_currency` varchar( 255 ) NOT NULL default '',
`currency_sign` varchar( 5 ) NOT NULL default '',
`demo_logo` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2
MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 37


What do i do ?
hexkid
Kurosaki-Ichigo wrote:
What do i do ?

Try

... DEFAULT CHARSET = utf8 ...


Your server database character set must be something different than latin1 and you cannot override the table character set like this (I think)
kv
Remove DEFAULT CHARSET=latin1 from your sql and it works.
Kurosaki-Ichigo
Did the think you said. Now this:

Quote:

SQL query:

ErrorSQL query : -- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 29 Mei 2006 om 15:27
-- Server versie: 4.1.11
-- PHP Versie: 5.1.2
--
-- Database: `scripts_videodev`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `settings`
--
CREATE TABLE `settings` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`seo_title` varchar( 255 ) NOT NULL default '',
`seo_keywords` varchar( 255 ) NOT NULL default '',
`seo_description` varchar( 255 ) NOT NULL default '',
`contact_sendto` varbinary( 255 ) NOT NULL default '',
`contact_pagetxt` text NOT NULL ,
`contact_active` tinyint( 1 ) NOT NULL default '0',
`gallery_active` tinyint( 1 ) NOT NULL default '0',
`faq_active` tinyint( 1 ) NOT NULL default '0',
`news_active` tinyint( 1 ) NOT NULL default '0',
`shop_active` tinyint( 1 ) NOT NULL default '0',
`features_active` tinyint( 1 ) NOT NULL default '0',
`paypal_id` varchar( 255 ) NOT NULL default '',
`paypal_currency` varchar( 255 ) NOT NULL default '',
`currency_sign` varchar( 5 ) NOT NULL default '',
`demo_logo` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2MySQL said : #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' AUTO_INCREMENT=2' at line 37

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.7.
jabapyth
you diddnt remove "DEFAULT CHARSET = latin1"!!!

do it.
kv
I will make it simple for you. Run this sql

Code:

CREATE TABLE `settings` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`seo_title` varchar( 255 ) NOT NULL default '',
`seo_keywords` varchar( 255 ) NOT NULL default '',
`seo_description` varchar( 255 ) NOT NULL default '',
`contact_sendto` varbinary( 255 ) NOT NULL default '',
`contact_pagetxt` text NOT NULL ,
`contact_active` tinyint( 1 ) NOT NULL default '0',
`gallery_active` tinyint( 1 ) NOT NULL default '0',
`faq_active` tinyint( 1 ) NOT NULL default '0',
`news_active` tinyint( 1 ) NOT NULL default '0',
`shop_active` tinyint( 1 ) NOT NULL default '0',
`features_active` tinyint( 1 ) NOT NULL default '0',
`paypal_id` varchar( 255 ) NOT NULL default '',
`paypal_currency` varchar( 255 ) NOT NULL default '',
`currency_sign` varchar( 5 ) NOT NULL default '',
`demo_logo` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM AUTO_INCREMENT =2
hilander
I am getting this error message when I try to run this script on phpmyadmin
Quote:
#1060 - Duplicate column name 'products_image_med'

since it is the first time I am using this,,it is probably that I am doing something wrong,,could anyone help me giving me some clues on this kind of error ? or the steps I have to follow to run a script in phpmyadmin,,,I would teally appreciate it,,
hilander
dont bother about the post above,,I think I found the problem,,thank you anyway,,if you werent there,,I would probably have quit long before,,thanks,,
Related topics
quicksilver Forum Install problem
install problem
Photoshop installation problem
vbs to silent install acrobat writer professional
vbs to silent install acrobat writer standard
SUSE and Ubuntu
Copying .avi to a dvd??
mySQL application install password problem in JSAS
How to solve this problem? Thanks
How do we install Invision Board manually through cpanel?
I cant install php chat tables nor set up diffrent subdomain
Permissions problem with Linux
Major Problem with COmputer. Help Please
Offer: I can install lots of things...
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.