vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   New Posting Features - Cel Photo Popup - Insert pictures from vB Albums, Attachs, Photopost, vBGallery (https://vborg.vbsupport.ru/showthread.php?t=243865)

cyberbob73 06-03-2010 05:13 PM

Quote:

Originally Posted by cellarius (Post 2047764)
You should post in english, if possible, as this is the language of this forum ;) I have a PPP setup with a different database up and running. To help you with a database error, it would be helpful to know what the error says.

Leider ist mein denglisch nicht so dolle :( Aber du wirst doch sicherlich dieses Addon auch auf vb-g.org ver?ffentlichen :confused: - dann warte ich eben solange ;)

cellarius 06-03-2010 05:19 PM

Quote:

Originally Posted by Jesh (Post 2047768)
Hello I am trying to do photopost only integration. My gallery is rather large

Gallery size should not matter.

Quote:

Do I need to set public ID's for this in config_photopost? If so, where can I get this list?
Default behaviour is for the popup to show only your own photos. So, if the user account has no photos uploaded, you will get that message. If you want to make all photos of a category available to all users, independent of who has uploaded them, you need to add the category id to the public ids list as described in the config file. There is no list for the category ids. You will find the id in the link to the category, for example: showgallery.php?cat=2.

Please mark the mod as installed.

cellarius 06-03-2010 05:20 PM

Quote:

Originally Posted by cyberbob73 (Post 2047772)
Leider ist mein denglisch nicht so dolle :( Aber du wirst doch sicherlich dieses Addon auch auf vb-g.org ver?ffentlichen :confused: - dann warte ich eben solange ;)

Das habe ich momentan nicht vor - mir ist es eigentlich zu m?hsam, in zwei Threads zu supporten. Was ich oben meinte: Bitte zitiere mal den vollst?ndigen Datenbankfehler.

cyberbob73 06-03-2010 05:26 PM

Quote:

Originally Posted by cellarius (Post 2047776)
Das habe ich momentan nicht vor - mir ist es eigentlich zu m?hsam, in zwei Threads zu supporten. Was ich oben meinte: Bitte zitiere mal den vollst?ndigen Datenbankfehler.

Ok - ist auch verst?ndlich.

Erstmal vorab, ich hab f?r vb4 und Photopost 2 Datenbanken

In die cel_pp_config_photopost.php hab ich die Daten der Photopost DB eingetragen.

Wenn ich nun ?ber den editor und dein Addon ein Bild aus Photopost einf?gen will, bekomm ich folgenden Fehler....

Quote:

Datenbankfehler in vBulletin 4.0.3:

Invalid SQL:

SELECT COUNT('id') AS fotos
FROM pp_photos
WHERE
(userid = 1
)
AND storeid = 0
AND approved = 1;

MySQL-Fehler : Table 'db284492_4.pp_photos' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Thursday, 03.06.2010 @ 20:21:19
Datum : Thursday, 03.06.2010 @ 20:21:20
Skript : http://www.meinewebseite.de/forum/ph...vB_Editor_QE_1
Referrer : http://www.meinewebseite.de/forum/sh...erbob73-testet
IP-Adresse : 95.208.180.241
Benutzername : cyberbob73
Klassenname : vB_Database
MySQL-Version : 5.1.45-log

Meine vb4 DB = db28xxxx_4
Meine PP DB = db28xxxx_3

Jesh 06-03-2010 05:28 PM

Quote:

Originally Posted by cellarius (Post 2047775)
Gallery size should not matter.

Default behaviour is for the popup to show only your own photos. So, if the user account has no photos uploaded, you will get that message. If you want to make all photos of a category available to all users, independent of who has uploaded them, you need to add the category id to the public ids list as described in the config file. There is no list for the category ids. You will find the id in the link to the category, for example: showgallery.php?cat=2.

Please mark the mod as installed.

Right, I know gallery size makes no difference, I was unsure if I had to specify categories. Ok, with that out of the way, it is still saying I have uploaded no images to the gallery.

I ran the query on the server and it is showing all uploads correctly with the Images Query. However, nothing is displaying for images.

Version:

Photo Popup Settings (from AdminCP)
num_of_cols: [3]
num_of_rows: [3]
num_total:9
widht: 600
heigth: 680
products: photopost attachments
insert_options_allowed: link_thumb_2_orig link_thumb_2_gallery link_med_2_orig link_med_2_gallery thumb med orig thumb_2_gallery_link_below med_2_gallery_link_below orig_2_gallery_link_below
allow_albums: 0
code_usergroups: 6
Code (this is what is inside the table cells)
Images query
SELECT id, userid, bigimage, cat, medsize FROM pp_photos WHERE (userid = 1 ) AND storeid = 0 AND approved = 1 ORDER BY date DESC LIMIT 0, 9
Albums query:
Pagination query: SELECT COUNT('id') AS fotos FROM pp_photos WHERE (userid = 1 ) AND storeid = 0 AND approved = 1
Link to Original
Link to Thumb
Used product: photopost
Albums possible: 1
Albums override:
Cookie
Read Cookie:
Set Cookie: photopost,,link_thumb_2_orig,1
Table building (rows and columns)


any ideas?

cellarius 06-03-2010 05:31 PM

Quote:

Originally Posted by cyberbob73 (Post 2047779)
Wenn ich nun ?ber den editor und dein Addon ein Bild aus Photopost einf?gen will, bekomm ich folgenden Fehler....

Quote:

MySQL-Fehler : Table 'db284492_4.pp_photos' doesn't exist

Die Tabelle pp_photos existiert nicht in der von Dir eingetragenen Datenbank. Ich vermute mal, Du verwendest entweder kein Tabellenpr?fix oder eines, das vom Standars abweicht ("pp_"). ?berpr?fe das in der Datenbank und in Deiner config:
Quote:

// Table prefix. pp_ is the default setting.
// You may have changed this on installation of Photopost Pro.
// Look for this in PP-Administration->Edit Config->PhotoPost Database Prefix
//
$db_prefix = "pp_";

cyberbob73 06-03-2010 05:38 PM

Doch das Pr?fix stimmt schon -

ABER

Die PP DB ist eben nicht db28xxxx_4 sondern db28xxxx_3

Und so hab ich das auch in die cel_pp_config_photopost.php eingetragen.

Aber auch wenn ich in der cel_pp_config_photopost.php die vb4 DB eintrage - bekomm ich gleichen Fehler.

Stimmt doch, das ich in die cel_pp_config_photopost.php meine Photopost DB Daten eintragen mu? ?

cellarius 06-03-2010 05:43 PM

Aktiviere den Debug-Modus und poste mal die Zeilen zu
Quote:

Photopost Settings (from config file, only if photopost is selected product)
Datadir:
Other DB?:
Name of db:


cyberbob73 06-03-2010 06:02 PM

Quote:

Originally Posted by cellarius (Post 2047796)
Aktiviere den Debug-Modus und poste mal die Zeilen zu

Das ist meine Ausgabe (Name of db: - diese Option gibt es bei mit gar nicht)
Photopost Settings (from config file, only if photopost is selected product)
Datadir: /
Other DB?:

cellarius 06-03-2010 06:13 PM

Aus irgend einem Grund wird bei Dir die $other_db = TRUE; nicht verwertet. Setze die Variable mal auf = 1; anstatt TRUE.


All times are GMT. The time now is 06:45 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01319 seconds
  • Memory Usage 1,756KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete