5151
cybermongo
Re: how to fusion two database ?
  • 2016/2/7 18:58

  • cybermongo

  • Just popping in

  • Posts: 27

  • Since: 2004/10/4


thnk you Mamba, there are too many record and actually these are not duplicated , the duplicate field is just the "storyid" in this incremente automaticly i will try the script below

SET @db:='id_new';   select @max_id:=max(AUTO_INCREMENTfrom information_schema.tables;  select concat('update ',table_name,' set 'column_name,' = ',column_name,'+',@max_id,' ; 'from information_schema.columns where table_schema=@db and column_name like '%id' into outfile 'update_ids.sql';  use id_new source update_ids.sql;
i will let you know any news



5152
Mamba
Re: how to fusion two database ?
  • 2016/2/7 18:29

  • Mamba

  • Moderator

  • Posts: 11373

  • Since: 2004/4/23


Depending on how many records are duplicate. If the number is small, you could use the "INSERT IGNORE", and then identify the duplicate records that were not inserted, changed manually their ID and then insert them.

Or you can follow this advice from StackOverflow:

Quote:
First, merge in a temporary table, with something like:

create table MERGED as select from table 1 uni-on select from table 2

Then, identify the primary key constraints with something like

SELECT COUNT(*), PK from MERGED GROUP BY PK HAVING COUNT(*) > 1

Where PK is the primary key field...

Solve the duplicates.

Rename the table.
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs



5153
Mamba
Re: Publisher 1.02 Final and pdf
  • 2016/2/7 17:36

  • Mamba

  • Moderator

  • Posts: 11373

  • Since: 2004/4/23


I'll look into it this week, unless somebody beats me to it (hopefully, somebody will!!!! )
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs



5154
SMEDrieben
Re: Publisher 1.02 Final and pdf
  • 2016/2/7 15:26

  • SMEDrieben

  • Not too shy to talk

  • Posts: 173

  • Since: 2009/6/17


What a pity that nobody has a solution !

Today I installed Publisher 1.02 Final in the production environment: Linux server, PHP 5.6.17. I copied the tcpdf to the xoops_lib directory. The makepdf doesn't work there either (with the debug mode on):

XOOPS URL not defined
Geen Alle Fouten 
(0Verouderd (1Queries (10Blokken (0Extra (2Timers(3)
Verouderd
Please 
use $pdf_data for configurationSee http://www.chg-web.org/ or ./docs/pdf_data.txt


Any suggestions how to get the makepdf working ? Thanks !

SMEDrieben



5155
cybermongo
how to fusion two database ?
  • 2016/2/7 15:08

  • cybermongo

  • Just popping in

  • Posts: 27

  • Since: 2004/10/4


hi every one, i need your help to join two Database of my two xoops website.
the module News create a post with a different ID that make an error when i try to paste de data just in one BD, because this look duplicate, please need your help, how to join these two database in just in one. all the the data are coming from Module news.
Cheers guys



5156
zyspec
Re: Latest XOOPS Tag & Cumulus Tag Module ?
  • 2016/2/5 18:30

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


By the way - the version of XOOPS Tag module that Mamba posted above no longer requires the Cumulus module. This version of XOOPS Tag includes a cloud (cumulus) block.



5157
zyspec
Re: Adding Search function to our Website
  • 2016/2/5 16:32

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


To find any errors that might lead us to the problem type a term in the search block and click the Search button. At the bottom of the page click on the "Error(s)" link and then let us know what is displayed. The output you showed us above is the SQL query that was made on your homepage instead of any error(s).

Since I can't remember if 2.0.16 administration panel displayed the system information the easiest way to find the PHP version is to do the following:
Create a file on your system with a text editor. You can call it anything but for simplicity just call it phpinfo.php with the following contents:

();


Upload this to the root folder (directory) on your web server using either an ftp client or your web server control panel (cpanel, etc). Go to your website and then type:

http://{YourWebsite}/phpinfo.php


A report of your PHP configuration will be displayed. The PHP version is displayed near the beginning. It might be useful for you to print this out in case you need it later.

Important: DELETE the phpinfo.php file from your webserver. This file can give a potential hacker useful information if you leave it for anyone to find.

You can find the version of the module (mastop-publish) by looking at the Admin panel > Module page. Please report the PHP and module versions back here so we can see if there's either a known problem or help you "dive in" to find the problem. I looked at the current version of mastop-publish and does support search.



5158
Mamba
Re: Latest XOOPS Tag & Cumulus Tag Module ?
  • 2016/2/5 8:32

  • Mamba

  • Moderator

  • Posts: 11373

  • Since: 2004/4/23


Quote:
Where can i find the latest version of these modules


1. XOOPS Tag
2. Cumulus Tag


Fork it, or just click on the "Download Zip" button...
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs



5159
Mamba
Re: Want to help
  • 2016/2/5 8:24

  • Mamba

  • Moderator

  • Posts: 11373

  • Since: 2004/4/23


Testing is always very important, but right now I would love everybody to focus on Documentation, especially from the User point of view - see this thread

Cifug, thank you so much for your offer to help! It is very much appreciated!

Could you help with Documentation?

You can read about our "Documentation Process", and then you can download or fork the "XOOPS Gitbook StarterKit"
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs



5160
pallanson
Re: Adding Search function to our Website
  • 2016/2/5 2:19

  • pallanson

  • Just popping in

  • Posts: 5

  • Since: 2016/2/3 2


Thanks for helping, Im new to Xoops so bear with me!
Answers are;
Version 1
PHP - Not sure where I can find this info
Global Search - Yes enabled

Debug-6 errors shows;
SELECT FROM xoops_config WHERE (conf_modid '0' AND conf_catid '1'ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id 
'XXX'
SELECT FROM xoops_users WHERE uid=1
SELECT 
FROM xoops_modules WHERE dirname 'system'
SELECT FROM xoops_configcategory
SELECT 
FROM xoops_group_permission WHERE (gperm_name 'module_admin' AND gperm_modid '1' AND (gperm_groupid '1' OR gperm_groupid '2'))


Does this help? Thanks




TopTop
« 1 ... 513 514 515 (516) 517 518 519 ... 29425 »



Login

Who's Online

741 user(s) are online (347 user(s) are browsing Support Forums)


Members: 0


Guests: 741


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits