Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 12358
Latest: KekoWorld
New This Month: 1
New This Week: 2
New Today: 1
Stats
Total Posts: 40081
Total Topics: 7056
Most Online Today: 63
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 56
Total: 57

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - G6

Pages: [1]
1
Code: [Select]
Error

SQL-question:

db_query(
"CREATE TABLE IF NOT EXISTS {$db_prefix}welcome (ID smallint(5) unsigned NOT NULL auto_increment, welcomesubject tinytext, welcomebody text, PRIMARY KEY (ID))", __FILE__, __LINE__
)

MySQL sa: Dokumentation
#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 'db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}welcome
(ID smallint(5) unsign' at line 1

Get this both through the manager and through the PHP myadmin

This is the SQL code thats in the WelcomeTopicsql.php file

Code: [Select]
db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}welcome
(ID smallint(5) unsigned NOT NULL auto_increment,
welcomesubject tinytext,
welcomebody text,
PRIMARY KEY (ID))", __FILE__, __LINE__);

db_query("REPLACE INTO {$db_prefix}settings VALUES ('welcome_boardid', '0')", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('welcome_memberid', '0')", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('welcome_membername', '')", __FILE__, __LINE__);

What am i doing wrong here  :-\

2
Site Discussion / Re: Manuall install description for SMF Gallery ?
« on: June 28, 2007, 03:26:38 am »
Yes the file edits i know how to do, i meant the Database installer.
I cant the installer for the database tables to execute from the browser and i cant use the package manager, so how do i get the database tables for SMF gallery to install ?

3
Site Discussion / Manuall install description for SMF Gallery ?
« on: June 27, 2007, 01:36:18 pm »
I have one server where i cant use the package manager as the owner of all the files turn out to be Apache when i use it, and that way i cant add or change anything in them after the install, so i have to install every thing manually.

Up to the point where i have to install the DB it works fine with reading the XML file, but how on earth do i get the DB tables to install as it will not work with pointing to the gallery_install.php, it doesent execute from the browser.
Any pointers in the right way ?

Thank you in advanced
//G6

4
SMF Gallery Lite / Re: SMF Gallery Lite Language Packs
« on: April 23, 2007, 04:28:14 pm »
Swedish utf8 for SMF-Gallery Lite V1.0

5
SMF Gallery Lite / Re: Show off your SMF Gallery Lite Forum!
« on: April 23, 2007, 04:22:22 pm »
http://www.familjegodis.se/forum/index.php?action=gallery

SMF Gallery lite

Images of me and my family

//G6

6
SMF Gallery Lite / Re: aero79 theme
« on: April 23, 2007, 04:20:39 pm »
Aero uses the default themes modifications.english.php

To add the gallery button in to the theme just copy the forum button code and change the url action to

Code: [Select]
<a href="', $scripturl, '?action=gallery">' , $txt['smfgallery_menu']  , '</a>
And the rest of the "forum" names to "gallery"


7
Modifications Talk / Re: SMF 1.1.2 and portals
« on: February 20, 2007, 12:45:22 pm »
Eather you have to install TP manually or use the package that IchBin have posted on Tinyportal.
Both ways work fine on SMF 1.1.2.
I even think IchBin updated the TP V0971 package in the downloadsection to work with SMF 1.1.2

8
SMF Gallery Lite / Re: SMF Gallery Lite Language Packs
« on: February 20, 2007, 12:43:04 pm »
The swedish files for SMF gallery lite 1.0
Translated the strings in the Gallery.template.php aswell in this package (offcourse leaving the copywrite intact)

9
edit.. and offcourse i found it right after i have made the first post

I will send it up in the language thread ;)

10
I have been using SMF gallery lite for some time now and are very happy with how easy it is to work with and also the easy interface and admin panel.

Last night i installed it to a new site that are in the works about my sons heart and his operations.
The site is going to be in swedish and as i have made translations for both SMF Tinyportal and Arcade i made it for SMF gallery light to.
I searched for other translation treads in here but it didnt return anything about it, so thats why i started this thread here. Im sorry if i posted compleatly wrong now, please move to the proper board.

But if you like to have the Swedish translation for SMF gallery light i will be happy to post the files for you.
Just say where and i send them up.

And again, thank you for a great mod to SMF, way better then all the struggle with Coppermine i had before

Pages: [1]

+- Recent Topics

Only variables should be passed by reference by SMFHacks
April 01, 2020, 01:42:18 pm

Cannot install Gallery Pro on SMF 2.1 RC2 by Hatshepsut
March 19, 2020, 12:55:00 am

Newbie questions by SMFHacks
March 08, 2020, 09:28:17 am

Update detect mobile mode PHP5 to PHP7 by Plus
March 05, 2020, 11:19:05 am

Just a hello by Plus
March 05, 2020, 11:05:56 am

Enotify Copyright Problem by SMFHacks
March 04, 2020, 09:21:09 pm

Cannot import by shawnb
March 02, 2020, 12:17:00 pm

Error message with latest SMF 2.1 Github build by Hatshepsut
March 01, 2020, 10:06:10 am

[Mod]Avatars Display Integration by SMFHacks
February 15, 2020, 07:30:47 pm

[Mod]BBC Message Boxes 1.0 by SMFHacks
February 15, 2020, 07:26:46 pm

Powered by EzPortal