MySQL fun :(

[Forse]

Well I've used this http://coppermine.sourceforge.net/oldboard/viewtopic.php?t=2493 to get my dynamic contect into gallery. And I have run into problems right away

PHP code gets parsed and I am happy, but after I got my dynamic conect to work..gallery stopped working. Let me give u details. My template.php has many parts and in one of them it uses mysql to connect and get info from forum like "latest news" bla bla bla...anyway I get this error:

Error prosessing database or something.

The minute I disable my other menu that uses mySQL...gallery starts working like never happened  :roll: I am kinda new to php so go easy on me.

Also can I ask how to make barebone template which only has albums and so without any eye candy...or maybe there is already one like that? I am searching for a slim and simple theme.

in any case thank you very much!

[Casper]

can't help you with part one of your post.

The default theme is the 'barebones' theme, with no 'eye candy', is very easy to change colours etc in style.css, and is the quickest download.

The 'water drop theme is also very good for this.

[Forse]

Is there some guide on how to create theme?

Thank you

P.S. Found out...no problem

The mysql error I get is "There was an error while processing a database query"

[Joachim Müller]

The mysql error I get is "There was an error while processing a database query"

turn on debug mode!

GauGau

[Forse]

I did I have gotten this as error in debug mode:

There was an error while processing a database query.

While executing query "DELETE FROM cpg11d_banned WHERE expiry < 1073686591" on 0

mySQL error: Table 'forums.cpg11d_banned' doesn't exist

Debug info
USER:

Array
(
    [ID] => a18bffd2ca0e22115fcfc0912f06f9c2
    [am] => 1
    [search] => ###kimi
    [liv] => Array
        (
           

• => 425
[1] => 1356
            [2] => 556
            [3] => 728
            [4] => 824
        )

    [lap] => 3
    [theme] => animeblitz
)
USER DATA:

Array
(
   
• => 1
[user_id] => 1
    [1] => Forse
    [user_name] => Forse
    [2] => 4
    [mgroup] => 4
    [3] => 4
    [group_id] => 4
    [4] => r00t
    [group_name] => r00t
    [5] => 0
    [group_quota] => 0
    [6] => 0
    [has_admin_access] => 0
    [7] => 1
    [can_rate_pictures] => 1
    [8] => 1
    [can_send_ecards] => 1
    [9] => 1
    [can_post_comments] => 1
    [10] => 1
    [can_upload_pictures] => 1
    [11] => 1
    [can_create_albums] => 1
    [12] => 1
    [pub_upl_need_approval] => 1
    [13] => 1
    [priv_upl_need_approval] => 1
)
Queries:

Array
(
   
• => SELECT id as user_id, name as user_name, mgroup FROM `forums`.ibf_members WHERE id='1' AND password='0184eb436279d0aa97e7d67a15f67f85'
[1] => SELECT * FROM cpg11d_usergroups WHERE group_id = '4'
    [2] => DELETE FROM cpg11d_banned WHERE expiry < 1073686591
)
GET :

Array
(
)
POST :

Array
(
)

My gallery uses "forums" database to get logins and "gallery" to store gallery specified things. The other code that uses mySQL also uses "forums" and if I remove it gallery works fine.

[Joachim Müller]

From the documentation - "Integrating the script with your bulletin board":

It is also recommended that you use the same database for your board and Coppermine.

GauGau

[Forse]

Thank you. Is there a way to transfer all content from "gallery" database over to "forums" without loosing any data?

[Joachim Müller]

use a tool like phpMyAdmin to create a dump of this very table inside your db "forums" and run the dump in the "gallery"-db. For details, refer to the phpMyAdmin documentation.

GauGau

[Forse]

I fixed the problem (just moved content from gallery to forums from shell). Anyway thank you for assistance