FRIHOST • FORUMS • FAQ • TOS • BLOGS • DIRECTORY
You are invited to Log in or Register a Frihost Account!

install problem

   Frihost Forum Index -> Scripting -> Php and MySQL
 


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,,
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

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