Aider moi je debute [Résolu]

Signaler
Messages postés
3
Date d'inscription
dimanche 11 mai 2008
Statut
Membre
Dernière intervention
14 mai 2008
-
Messages postés
3
Date d'inscription
dimanche 11 mai 2008
Statut
Membre
Dernière intervention
14 mai 2008
-
voilas je suis heberger chez 1and1 j ai deposer la base de donner de mon script mais des que je lexecute il me repond :
MySQL a répondu:http://dev.mysql.com/doc/mysql/en/Error-returns.html

#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=9' at line 11

voici la partie ou se trouve l erreur mais je ne trouve pas :


requête SQL:

--
-- Table structure for table `adv`
--
CREATETABLE`adv`(
`adv_id`bigint(20)NOTNULLAUTO_INCREMENT,
`adv_name`varchar(255)NOTNULLdefault'',
`adv_text`textNOTNULL,
`adv_status`enum('Active','Inactive')NOTNULLdefault'Active',
PRIMARYKEY(`adv_id`)
)ENGINE =MYISAMDEFAULTCHARSET=latin1AUTO_INCREMENT=9

--
-- Dumping data for table `adv`
--

INSERT INTO `adv` VALUES (8, 'resolution_based_right_add', 'This is my right side ads', 'Active');
INSERT INTO `adv` VALUES (4, 'video_right_single', '
VIDEO RIGHT SINGLE
ADS

', 'Inactive');
INSERT INTO `adv` VALUES (5, 'home_top_single', 'Home Top Single Ads', 'Active');
INSERT INTO `adv` VALUES (7, 'resolution_based_left_add', 'This is my left side ads', 'Active');
INSERT INTO `adv` VALUES (2, 'foot_top_banner', '\r\n----
\r\n  \r\n   \r\n     Foot Top Advertise\r\n   \r\n , \r\n\r\n
', 'Active');
INSERT INTO `adv` VALUES (6, 'foot_bottom_banner', 'This is footer bottom banner', 'Active');
INSERT INTO `adv` VALUES (3, 'home_right_box', '
HOME RIGHT BOX
Advertisement Here

Edit / Enable / Disable from Admin Panel
', 'Active');
INSERT INTO `adv` VALUES (1, 'home_top_banner', '<center>
HOME TOP BANNER
Advertisement Here
Edit / Enable / Disable from Admin Panel
</center>
', 'Active');

-- --------------------------------------------------------

de l aide je n en dort plus

2 réponses

Messages postés
3
Date d'inscription
dimanche 11 mai 2008
Statut
Membre
Dernière intervention
14 mai 2008

desoler j ai trouver en fait je rentrer ma base de donner en sql 4 or il fallait que je la met en sql5 c est chose faite c bon par contre voici un nouveau souci :

"

Fatal error: Call to undefined function: adonewconnection() in /homepages/25/d146395061/htdocs/include/config.php on line 77"

 
je suis aller sur le script "config.php" a la ligne 77mais je ne voie rien de speciale voici le bout du script :

 
session_start();

$config = array();
// CONFIGURATION

// Your Website Name

$config['site_name']  = "montageonline";

$config['BASE_DIR']   = 'http://www.defouliore.be/';

$config['BASE_URL']   = 'http://www.defouliore.be/';

$config['tmpimgpath']  = 'http://www.defouliore.be/tmp';

$config['tmpimgpath2'] = 'http://www.defouliore.be/tmp';

$config['ffmpeg']    = '/usr/bin/ffmpeg';

$config['mplayer']   = '/usr/bin/mplayer';

$config['mencoder']   = '/usr/bin/mencoder';

$config['metainject']  = '/usr/bin/flvtool2';

$config['phppath']   = '/usr/local/bin/php';

// Guest users (unregistered) daily limit (duration in seconds)

$config['guest_limite'] = 65535;
// Videos have to be approved by admin before made public (1 yes / 0 no)

$config['approve']   = 0;
// Delete original uploaded videos (and temp files) after successful conversion (1 yes / 0 no)

$config['del_original_video'] = 0;

// User profile photo (avatar) width (pixels). Original uploaded images are redimensioned

$config['photowidth']  = "150";

// Video Bitrate (kbit/sec)- Increase/Decrease quality/filesize of the converted video

$config['vbitrate']   = 800;

// Audio Sample Rate (Hz) – Recommended to leave it to this value

$config['sbitrate']   = 22050;
// Resize/Scale Converted Video (yes 1 / no 0)

$config['vresize']   = 0;

//Resized Video Width

$config['vresize_x']  = 320;

//Resized Video Height

$config['vresize_y']  = 240;

//Captcha (Signup Image Verification) ON=1/OFF=0

$config['captcha']   = 1;

//Member Download Videos ON=1/OFF=0

$config['downloads']  = 1;
// DO NOT EDIT UNDER THIS LINE

$config['CONF_FILE'] = $config[BASE_DIR] . '/include/conf.ini';

$config['IMG_DIR']  = $config[BASE_DIR] . '/images';

$config['IMG_URL']  = $config[BASE_URL] . '/images';

$config['PHO_DIR']  = $config[BASE_DIR] . '/photo';

$config['PHO_URL']  = $config[BASE_URL] . '/photo';

$config['VDO_DIR']  = $config[BASE_DIR] . '/video';

$config['VDO_URL']  = $config[BASE_URL] . '/video';

$config['ADO_DIR']  = $config[BASE_DIR] . '/audio';

$config['ADO_URL']  = $config[BASE_URL] . '/audio';

$config['FLVDO_DIR'] = $config[BASE_DIR] . '/flvideo';

$config['FLVDO_URL'] = $config[BASE_URL] . '/flvideo';

$config['TMB_DIR']  = $config[BASE_DIR] . '/thumb';

$config['TMB_URL']  = $config[BASE_URL] . '/thumb';

$config['baseurl']  = $config['BASE_URL'];

$config['basedir']  = $config['BASE_DIR'];

$config['vdodir']   = $config['VDO_DIR'];

$config['vdourl']   = $config['VDO_URL'];

$config['audiodir']  = $config['ADO_DIR'];

$config['audiourl']  = $config['ADO_URL'];

$config['flvdodir']  = $config['FLVDO_DIR'];

$config['flvdourl']  = $config['FLVDO_URL'];

$config['photodir']  = $config['PHO_DIR'];

$config['photourl']  = $config['PHO_URL'];

$config['imgurl']   = $config['IMG_URL'];

$config['imgpath']  = $config['IMG_DIR'];

$config['tmbdir']   = $config['TMB_DIR'];

$config['tmburl']   = $config['TMB_URL'];

require_once ($config[BASE_DIR] . '/smarty/libs/Smarty.class.php');

require_once ($config[BASE_DIR] . '/classes/mysmarty.class.php');

require_once ($config[BASE_DIR] . '/classes/SConfig.php');

require_once ($config[BASE_DIR] . '/classes/SError.php');

require_once ($config[BASE_DIR] . '/include/adodb/adodb.inc.php');

require_once ($config[BASE_DIR] . '/include/phpmailer/class.phpmailer.php');

require_once ($config[BASE_DIR] . '/classes/SEmail.php');

require_once ($config[BASE_DIR] . '/include/dbconfig.php');

$conn =&ADONewConnection($DBTYPE);
$conn->PConnect($DBHOST, $DBUSER, $DBPASSWORD, $DBNAME);

$sql = "SELECT * from sconfig";

$rsc = $conn->Execute($sql);

if ($rsc)

merci pour votre aide
Messages postés
3
Date d'inscription
dimanche 11 mai 2008
Statut
Membre
Dernière intervention
14 mai 2008

"

Fatal error: Call to undefined function: adonewconnection() in /homepages/25/d146395061/htdocs/include/config.php on line 77"

 
je suis aller sur le script "config.php" a la ligne 77mais je ne voie rien de speciale voici le bout du script :

 
session_start();

$config = array();
// CONFIGURATION

// Your Website Name

$config['site_name']  = "montageonline";

$config['BASE_DIR']   = 'http://www.defouliore.be/';

$config['BASE_URL']   = 'http://www.defouliore.be/';

$config['tmpimgpath']  = 'http://www.defouliore.be/tmp';

$config['tmpimgpath2'] = 'http://www.defouliore.be/tmp';

$config['ffmpeg']    = '/usr/bin/ffmpeg';

$config['mplayer']   = '/usr/bin/mplayer';

$config['mencoder']   = '/usr/bin/mencoder';

$config['metainject']  = '/usr/bin/flvtool2';

$config['phppath']   = '/usr/local/bin/php';

// Guest users (unregistered) daily limit (duration in seconds)

$config['guest_limite'] = 65535;
// Videos have to be approved by admin before made public (1 yes / 0 no)

$config['approve']   = 0;
// Delete original uploaded videos (and temp files) after successful conversion (1 yes / 0 no)

$config['del_original_video'] = 0;

// User profile photo (avatar) width (pixels). Original uploaded images are redimensioned

$config['photowidth']  = "150";

// Video Bitrate (kbit/sec)- Increase/Decrease quality/filesize of the converted video

$config['vbitrate']   = 800;

// Audio Sample Rate (Hz) – Recommended to leave it to this value

$config['sbitrate']   = 22050;
// Resize/Scale Converted Video (yes 1 / no 0)

$config['vresize']   = 0;

//Resized Video Width

$config['vresize_x']  = 320;

//Resized Video Height

$config['vresize_y']  = 240;

//Captcha (Signup Image Verification) ON=1/OFF=0

$config['captcha']   = 1;

//Member Download Videos ON=1/OFF=0

$config['downloads']  = 1;
// DO NOT EDIT UNDER THIS LINE

$config['CONF_FILE'] = $config[BASE_DIR] . '/include/conf.ini';

$config['IMG_DIR']  = $config[BASE_DIR] . '/images';

$config['IMG_URL']  = $config[BASE_URL] . '/images';

$config['PHO_DIR']  = $config[BASE_DIR] . '/photo';

$config['PHO_URL']  = $config[BASE_URL] . '/photo';

$config['VDO_DIR']  = $config[BASE_DIR] . '/video';

$config['VDO_URL']  = $config[BASE_URL] . '/video';

$config['ADO_DIR']  = $config[BASE_DIR] . '/audio';

$config['ADO_URL']  = $config[BASE_URL] . '/audio';

$config['FLVDO_DIR'] = $config[BASE_DIR] . '/flvideo';

$config['FLVDO_URL'] = $config[BASE_URL] . '/flvideo';

$config['TMB_DIR']  = $config[BASE_DIR] . '/thumb';

$config['TMB_URL']  = $config[BASE_URL] . '/thumb';

$config['baseurl']  = $config['BASE_URL'];

$config['basedir']  = $config['BASE_DIR'];

$config['vdodir']   = $config['VDO_DIR'];

$config['vdourl']   = $config['VDO_URL'];

$config['audiodir']  = $config['ADO_DIR'];

$config['audiourl']  = $config['ADO_URL'];

$config['flvdodir']  = $config['FLVDO_DIR'];

$config['flvdourl']  = $config['FLVDO_URL'];

$config['photodir']  = $config['PHO_DIR'];

$config['photourl']  = $config['PHO_URL'];

$config['imgurl']   = $config['IMG_URL'];

$config['imgpath']  = $config['IMG_DIR'];

$config['tmbdir']   = $config['TMB_DIR'];

$config['tmburl']   = $config['TMB_URL'];

require_once ($config[BASE_DIR] . '/smarty/libs/Smarty.class.php');

require_once ($config[BASE_DIR] . '/classes/mysmarty.class.php');

require_once ($config[BASE_DIR] . '/classes/SConfig.php');

require_once ($config[BASE_DIR] . '/classes/SError.php');

require_once ($config[BASE_DIR] . '/include/adodb/adodb.inc.php');

require_once ($config[BASE_DIR] . '/include/phpmailer/class.phpmailer.php');

require_once ($config[BASE_DIR] . '/classes/SEmail.php');

require_once ($config[BASE_DIR] . '/include/dbconfig.php');

$conn =&ADONewConnection($DBTYPE);
$conn->PConnect($DBHOST, $DBUSER, $DBPASSWORD, $DBNAME);

$sql = "SELECT * from sconfig";

$rsc = $conn->Execute($sql);

if ($rsc)

desoler voici la ligne 77 en rouge